Storing Greek into the SQL 2000

[avgoustinosc]

Hi guys,
I am using nvarchar in order to be able to enter Greek into the SQL database. Everything looks that it works fine except one field which is text. I am changing this field into ntext and also i tryied nvarchar and Greek_CI_IS and this field only it doesnt store any Greek.

Any suggestions?
Your help is appreciated.

[kaffenils]

Still having problems with those letters?

What application do you use to enter the greek letter into the database, and what application is it that cannot see the greek letters.

When you use unicode (nvarchar, ntext) then you can store a mix of chinese, arabic, greek letters. The only thing that can go "wrong" is if your client doesn't support unicode. If you are using VB og .Net then this should not be a problem as they both handle strings in UTF-16 format.

I am guessing that the client uses a font that doesn't support unicode characters.