Posted by Erland Sommarskog on 12/17/07 22:45

(rsam2011@yahoo.com) writes:
> I have a strange problem with an application running on Windows 2000
> connecting to a SQL Server 2000 with Greek collation.
>
> Runnin this query on the SQL
> "SELECT serverproperty('Collation'),
> databasepropertyex('mydb', 'Collation')"
> gives me:
> SQL_Latin1_General_CP1_CI_AS, Greek_CI_AI
>
> When I run my application on my Windows XP machine I have no problems
> with the characters however when I try the same applicaton on a
> Windows 2000 platform the Greek characters are lost. For example the
> Greek characters TI appear as OE.

Is the Greek data in varchar or nvarchar?

Do you know which version of the MDAC there is on the Win 2000 machine?
Could you try installing MDAC 2.8 SP1?


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