sql_collation_examples.sql

CREATE TABLE RockClub (
	ID INT IDENTITY(1, 1), 
	Address_NS NVARCHAR(128) COLLATE SQL_Latin1_General_CP1_CI_AI,
	Address_VS VARCHAR(128) COLLATE SQL_Latin1_General_CP1_CI_AI,
	Address_NW NVARCHAR(128) COLLATE Latin1_General_CI_AI,
	Address_VW VARCHAR(128) COLLATE Latin1_General_CI_AI
)

INSERT INTO RockClub (Address_NS, Address_VS, Address_NW, Address_VW) VALUES (N'Saarbrücker Straße 24, 10405 Berlin','Saarbrücker Straße 24, 10405 Berlin',N'Saarbrücker Straße 24, 10405 Berlin','Saarbrücker Straße 24, 10405 Berlin')

SELECT * FROM RockClub WHERE Address_NW LIKE '%saarbrucker strasse%' 
SELECT * FROM RockClub WHERE Address_NW LIKE '%saarbrucker strasse%' COLLATE Latin1_General_CI_AI
SELECT * FROM RockClub WHERE Address_NW LIKE '%saarbrucker strasse%' COLLATE SQL_Latin1_General_CP1_CI_AI

SELECT * FROM RockClub WHERE Address_VW LIKE '%saarbrucker strasse%' 
SELECT * FROM RockClub WHERE Address_VW LIKE '%saarbrucker strasse%' COLLATE Latin1_General_CI_AI
SELECT * FROM RockClub WHERE Address_VW LIKE '%saarbrucker strasse%' COLLATE SQL_Latin1_General_CP1_CI_AI

SELECT * FROM RockClub WHERE Address_NS LIKE '%saarbrucker strasse%' 
SELECT * FROM RockClub WHERE Address_NS LIKE '%saarbrucker strasse%' COLLATE Latin1_General_CI_AI
SELECT * FROM RockClub WHERE Address_NS LIKE '%saarbrucker strasse%' COLLATE SQL_Latin1_General_CP1_CI_AI

SELECT * FROM RockClub WHERE Address_VS LIKE '%saarbrucker strasse%' 
SELECT * FROM RockClub WHERE Address_VS LIKE '%saarbrucker strasse%' COLLATE Latin1_General_CI_AI
SELECT * FROM RockClub WHERE Address_VS LIKE '%saarbrucker strasse%' COLLATE SQL_Latin1_General_CP1_CI_AI

SELECT * FROM RockClub WHERE Address_NW LIKE N'%saarbrucker strasse%'
SELECT * FROM RockClub WHERE Address_NW LIKE N'%saarbrucker strasse%' COLLATE Latin1_General_CI_AI
SELECT * FROM RockClub WHERE Address_NW LIKE N'%saarbrucker strasse%' COLLATE SQL_Latin1_General_CP1_CI_AI

SELECT * FROM RockClub WHERE Address_VW LIKE N'%saarbrucker strasse%' 
SELECT * FROM RockClub WHERE Address_VW LIKE N'%saarbrucker strasse%' COLLATE Latin1_General_CI_AI
SELECT * FROM RockClub WHERE Address_VW LIKE N'%saarbrucker strasse%' COLLATE SQL_Latin1_General_CP1_CI_AI

SELECT * FROM RockClub WHERE Address_VW LIKE N'%saarbrucker strasse%' 
SELECT * FROM RockClub WHERE Address_VW LIKE N'%saarbrucker strasse%' COLLATE Latin1_General_CI_AI
SELECT * FROM RockClub WHERE Address_NS LIKE N'%saarbrucker strasse%' COLLATE SQL_Latin1_General_CP1_CI_AI

SELECT * FROM RockClub WHERE Address_VS LIKE N'%saarbrucker strasse%' 
SELECT * FROM RockClub WHERE Address_VS LIKE N'%saarbrucker strasse%' COLLATE Latin1_General_CI_AI
SELECT * FROM RockClub WHERE Address_VS LIKE N'%saarbrucker strasse%' COLLATE SQL_Latin1_General_CP1_CI_AI