Hi there,

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.

Any help is appreciated,
regards
BOB

(rsam2011 (AT) yahoo (DOT) com) writes:
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 (AT) sommarskog (DOT) se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

Hi Erland,

The Greek data is in Varchar.

The Windows 2000, had MDAC 2.53 installed. I installed the latest MDAC
v2.8 and it is now working fine with Greek characters.

Thanks a lot,
regards,
Robert Sammut