I have a table content in my database. This table has 5 fields(id, lang1, lang2 ...) type text. The problem is that one of the language fields has to contain some text in Cyrillic but after insert it always converts the text into "?? ????? ????". Can anyone help?
What you are getting is called character conversion but you are lucky I have helped someone at another site with Cyrillic character conversion. You enable column level collation for all the langauges your site support and the problem will be resolved. You need Enterprise manager to do it manually so use the link below to download the Eval version of SQL Server install it as a named instance and register your MSDE and in Query Analyzer right click on the tables in question and generate the create table statement and modify it to include the collation of all the languages used in the database. Run a search for column level collation in the BOL (books online). If you need more help post again. Hope this helps.
http://www.microsoft.com/sql/evaluation/trial/default.mspx
No comments:
Post a Comment