> 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/
This archive was generated by hypermail 2.1.2 : Wed Dec 19 2001 - 10:38:16 EST