View Single Post

   
  #1 (permalink)  
Old 03-01-2008, 02:46 PM
rsam2011@yahoo.com
 
Posts: n/a
Default Wrong Greek characters on Windows 2000

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
Reply With Quote