Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 Querying different languages

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-08-21 : 14:25:02
Ryan Michaels writes "I have a database with a table: 3 columns w/ each being a nvarchar datatype. One field is english, the other is italian, and the last is greek.

Querying the english and italian fields works just fine, but when I query the greek column (from VB using ADO 2.6), it comes back like "???Óàáà?? ?" replacing unknown characters that don't exist in ASCII with "?". SQL server enterprise manager displays full greek just fine when I open a table for viewing.

I have installed the greek language pack for Windows 2000 and I've installed the greek language updates for MDAC 2.6, and the information still will not return the way it should.

Any ideas?"
   

- Advertisement -