Posted by Erland Sommarskog on 02/15/06 01:26

iSt (saygin@gmail.com) writes:
> Exact collation is SQL_Latin1_General_CP1_CI_AS.
> Not all characters are mashed, ç (c with credila) is ok, however
> dotless i becomes y. ü (u with dots) are ok, however s (s with
> credila) and g (g with ~ over it) becomes ? (question mark)

Are you using varchar or nvarchar?

If you are using varchar you are fighting an uphill battle. The code
page SQL_Latin1_General_CP1_CI_AS is CP1252 which is not the best
code page for Turkish.

You should use a collation with code page 1254, for instance
SQL_Latin1_General_CP1254_CI_AS or any of the collations with
the name starting with Turkish.





--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]