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

• Next in forum: Re: Expanding Hierarchies - SQL 2000
• Prev in forum: Re: 2005 Stored Procedure Question - How to pass in additional LIKE conditions
• Thread view: Re: Wrong Greek characters on Windows 2000

[Reply to this message]