Posted by J.O. Aho on 11/23/06 19:45

Pugi! wrote:
> A nvarchar is a varchar (only ascii) for unicode text on MS SQL-server.
> How do you use varchar on mysql for unicode ?
> If you use a varchar(100) will the maximum number of characters be
> independent of the characterset (latin, japanese, chinese, ...) or will
> a japanese or chinese characterset will not be able to store 100
> characters ?

Don't have any good answer for this, more than take a look at the mysql
documentation, http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html

For sure if you try to store utf-8 characters in an iso-8859-1 table, you will
waste up the space a lot faster for cjk text. If using utf-8/ucs-2, then one
character should logically take one space, no matter if it's one-byte
sequence, two-byte sequence or three-byte sequence.


alt.php.sql had IMHO been a lot better newsgroup to ask this question.


//Aho

[Back to original message]