Which collation is sql latin1 general cp1 ci as

Please refer to the below T-SQL script which creates a column with the specified collation:. To view the collation of a column on the table, execute the following stored procedure with the table name as a parameter:.

Now let us query the Product table. Please refer to the below image it returns two rows and ignores case as the collation is case insensitive. Check out the below image that shows only one row in the result set as we have specified the collation in the select statement which is case sensitive:. For the demo purpose, I am creating two tables Products and ProductDesc with different collation on the column Pcode. Use the below T-SQL script:.

This is because the collation of the column Pcode in both tables are different:. The collation of the tempdb will be the same as the collation of the SQL Server instance. In some cases, we may use different collations at the database level and server level. In this case, we may run to issues if we use temporary tables and making joins with the tables in the database.

Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Explaining the semiconductor shortage, and how it might end. Does ES6 make JavaScript frameworks obsolete? Featured on Meta. Now live: A fully responsive profile.

Linked 0. Related Hot Network Questions. Create a free Team What is Teams? Learn more. Ask Question. Asked 5 years, 11 months ago. Active 5 years, 11 months ago. Viewed 6k times. Improve this question. Marco Marsala Marco Marsala 1 1 silver badge 5 5 bronze badges. I presume the 1 is for "Windows Latin 1" — Martin Smith. Add a comment. Active Oldest Votes. Improve this answer.