Problem Saving and retrieving Unicode Character
-
Hi I'm developing a site which contain Armenian Unicode Characters I have problem to save data into Ms Sql . I kind of sure I do not choose the right collation for my Database but I do not know which collation should I choose . I choose Cyrlic_General_CL_AS for my DataBase . Some one say that the charset should Mach to work correctly I set the Character set of my page to charset="windows-1251" Help me if I choose the wrong Collation and what is the right one ? or should I change something in my page characterSet ? Thanks
-
Hi I'm developing a site which contain Armenian Unicode Characters I have problem to save data into Ms Sql . I kind of sure I do not choose the right collation for my Database but I do not know which collation should I choose . I choose Cyrlic_General_CL_AS for my DataBase . Some one say that the charset should Mach to work correctly I set the Character set of my page to charset="windows-1251" Help me if I choose the wrong Collation and what is the right one ? or should I change something in my page characterSet ? Thanks
Hi simple set the row to nvchar which means all chars allowed and when you query use: N'unicodevalue' eg: INSERT INTO table Values(N'α-KTX3.1',someotherval) SELECT * FROM table WHERE field='α-KTX3.1' N'blehbleh' forces sql to interpret as unicode Hope this helps Atul
-
Hi simple set the row to nvchar which means all chars allowed and when you query use: N'unicodevalue' eg: INSERT INTO table Values(N'α-KTX3.1',someotherval) SELECT * FROM table WHERE field='α-KTX3.1' N'blehbleh' forces sql to interpret as unicode Hope this helps Atul
-
Oooh Man ! Hi That was a real help . Thanks a lot I am totally in the wrong path . and never can get what I want . I am about to change the Character to it 's UTF8 code then save that in my Sql DataBase. I hope I can return a favour .