:::: MENU ::::

Invalid collation ‘%.*ls.

  • Mar 21 / 2009
  • 0
dbDigger, SQL Server Collations

Invalid collation ‘%.*ls.

The error message

Msg 448, Level 16, State 3, Line 14
Invalid collation ‘%.*ls’.

is a run time error message and may be generated at all versions of SQL Server. The reason for this error is use of unknown collation in a command. To remove the error specified collation name may be corrected first. Collations control the physical storage of character strings in SQL Server. Separate collations can be specified down to the column level in a table, and each column can be assigned different collations. To get list of available collations in SQL Server use following script

 
USE DBNamehere  
 GO  
 SELECT *  
 FROM ::fn_helpcollations()  
 GO  

In case of SQL Server 2005 and onwards full colons may be removed from prefix of functions. Syntax for list of all collations in SQL Server 2005 and onwards will be

 
USE DBNamehere  
 GO  
 SELECT *  
 FROM fn_helpcollations()  
 GO  
Consult us to explore the Databases. Contact us