MS SQL Greek Lettering, collation and unicode 1200

[Spanky3]

Hi, I am currently working on a project recording names of toxins. Some of them have greek lettering and i have found a major problem with MSSQL. When i came across the character 'ω' which is omega MSSQL inserts it as a ? where it occurs. I have read around and found it seems to be with collation settings. If i copy and paste a 'ω' into a asp.net page it says i need to save the page with encoding unicode 1200 which works fine. When setting collation with MS SQL there is no code 1200 option so i dont know what to do :( Even microsoft access by default allows me to use 'ω' but surely there there is a way to do this with an enterprise class DB as MS SQL ? Please help i'm pulling my hair out! :confused::confused::confused::((:((:((

[Jeff Varszegi]

I still haven't worked with other code pages in MSSQL yet, although I want to sometime. Have you tried playing around with NVARCHAR yet? Sorry, it's the only thing I can think of off the top of my head. Thank you. Jeff Varszegi

[Anonymous]

i found my answer use N'stringwhichhasunicode' instead of just using 'stringwhichhasunicode' whenever you use an instance of it. EG: INSERT INTO TABLE VALUES(N'value1','value2' SELECT * FROM TABLE WHERE Column = N'unival' Atul