> I'm still impressionate by the multilanguage page you done (http://www.trigeminal.com/samples/provincial.html) and thanks again to > help me to use unicode with database.
My pleasure :-) > PS: With all fonts I have, I can see all the texts in the page > except this one : > ???? ?????? ?????? ??? ??? > but sorry, I can't tell which font is used and if theses fonts > are free of rights. I am not sure what language that is, actually? > 1) What kind of file are the .eot files used in the style > definition of the page ? EOT files are font files, creations of WEFT (dicussed in the third paragraph of the page with a link to more information). > 2) It's seems that the informations insertted into the database > are inserted with the same encoding that the page containing > the form. As I working with "utf-8" encoding, it's seems all > my datas are in "utf-8" encoding in the database, So when I > wish to paste datas directly into a field (with SQL server > Enterprise Manager) I need to copy/paste in "utf-8" format. > With this format, I cannot see the text correctly with the > Enterprise Manager. > But I can also paste data in "Unicode" format in the > Enterprise Manager which it's correctly displayed in the > Enterprise Manager but not on the web page (because it's > not utf-8 encoding). > I thing it's not correct to stock datas in "utf-8". Moreover, a > japanese kana/kanji in utf-8 still need 3 characters lenght of > a "nvarchar" type string. > Have an idea ? Well, MS SQL Server does not support UTF-8 encoding in any version; you should be using UTF-16 for Unicode text. But if you are copying/pasting from Internet Explorer, it should be doing all the work for you here -- all conversions should happen there. You should actually look at the white paper on international features of SQLS 2000 (covers 7.0 as well): http://www.microsoft.com/sql/techinfo/development/2000/intfeatures.asp (all on one line) for more info on how to deal with SQLS here. You should definitely not be storing UTF-8 anywhere -- UTF-8 is great for the web but there is almost nowhere else on the Windows platform where it makes sense (since it uses UTF-16 anywhere it uses Unicode). MichKa Michael Kaplan Trigeminal Software, Inc. -- http://www.trigeminal.com/
