This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Gouache painting of two different travel power plugs facing one wall socket, with a small vermilion adapter resting between them.

Cannot Resolve the Collation Conflict (Msg 468): SQL in Sixty Seconds #047

April 3, 2013
Pinal Dave
SQL Video
SQL Collation, SQL Column, SQL Error Messages, SQL in Sixty Seconds

Cannot resolve the collation conflict is Msg 468, and it appears when two text columns use different collations. I reproduced it on SQL Server 2025 with a temp table, found the mismatched columns with a query and tested three fixes, from a COLLATE clause in the query to changing the column itself.

Read More
Gouache painting of two trays of buttons, one mixed together and one sorted by size, with one large red button

Effect of Collation on Result Sets in SQL Server

September 19, 2012
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Group By, SQL Order By, SQL Scripts

The effect of collation on result sets is easy to see once you run the same query against two collations. This post builds a small demo and shows how sorting, comparing and grouping change. It also explains collation conflicts, including the one temp tables cause.

Read More
Two hands moving a young tomato plant with its roots intact from a small pot into a prepared garden bed

Moving From LocalDB to a Real Instance

September 15, 2012
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Collation, SQL Migration, SQL Server, SQL Server Express

Moving from LocalDB to a server instance takes a tested backup and restore, new connection strings, mapped logins, and a collation check.

Read More
Table comparing the digit 2 with its full-width form, and E=mc2 with E=mc squared, under Latin1_General_CI_AI, which is width insensitive and treats them as equal, and Latin1_General_CI_AI_WS, which is width sensitive and treats them as different

Width Sensitive and Width Insensitive Collation: An Example

July 14, 2012
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Server, Unicode

What is a width sensitive collation? I explain it with a simple example that compares half-width and full-width characters under both collation settings.

Read More
Two hands holding a daisy chain of joined flowers, a single loose daisy on the grass beside them

Storing Emoji and Short Messages: nvarchar, UTF-8 and Length

April 9, 2012
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Datatype, SQL Server, SQL String, Unicode

Store emoji safely with nvarchar or UTF-8 varchar, compare LEN and DATALENGTH, and choose message limits that fit full Unicode.

Read More
Two nearly identical white teacups on saucers, one with a small mark on its rim.

Collation Sensitivity Quiz: Does ‘jose’ Match ‘José’?

January 7, 2012
Pinal Dave
SQL Puzzle
SQL Collation, SQL Error Messages, SQL String, Unicode

This Collation Sensitivity Quiz asks whether jose matches JOSE and José in a case-insensitive, accent-sensitive database. The answer is JOSE yes, José no. A tested script compares three collations and shows the width and kana settings too.

Read More
SQL SERVER - Detecting Database Case Sensitive Property using fn_helpcollations()

SQL SERVER – Detecting Database Case Sensitive Property using fn_helpcollations()

October 6, 2011
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL DMV, SQL Function, SQL Scripts, SQL Server

Is your database Case Sensitive? Find its collation, then look it up in fn_helpcollations() and read the description. A quick answer from my Office Hours.

Read More
Previous 1 2 3 4 5 6 7 8 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com