468,514 Members | 1,686 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,514 developers. It's quick & easy.

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
Dec 17 '07 #1
2 1960
(rs******@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, es****@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
Dec 17 '07 #2
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
Dec 21 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by sharma | last post: by
5 posts views Thread by Vangelis Natsios | last post: by
27 posts views Thread by alexdoulou | last post: by
9 posts views Thread by PAN | last post: by
reply views Thread by NPC403 | last post: by
1 post views Thread by fmendoza | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.