Posted by Erland Sommarskog on 02/11/06 20:08

(saygin@gmail.com) writes:
> We are developing an add-on for GoldMine, however my problem is a
> generic SQL Server problem. The situation is this; we have a database,
> with collation set to SQL Latin. When we connect to database via
> Goldmine, Enterprise Manager or Delphi (through ADO) we cannot see
> Turkish characters. When I set SQL Server machine's "Language For
> Non-Unicode Programs" setting to Turkish, GoldMine works fine, however
> there is still problem in EM and Delphi.
> Does anybody know how to solve this issue?

What datatype does the columns have? varchar or nvarchar?

Exactly which collation are you using? There are a whole number of
collations with the name starting with "SQL_Latin".

Do all Turkish characters get mashed? Or only some? Does ç (lowercase C with
cedilla) work? If not, how do you see it in EM? How does the dotless
lowercase i get represented?

Which client API do you use in Delphi?

--
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]