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 is appreciated,
regards
BOB

(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/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