Re: some questions related to Unicode

[Veera Swamy]

Hi Peter, thanks a lot for the replies. I really appreciate that.

Just a little more :)

"Sometimes people add their own collations"; How can i add my own collation? Can i instantly change how mysql sorts data by a command something like "set collation"


?if i have a table with multi-lingual data, one record is english, the other is
chinese, the other is japanese; is there a way for me to know what language the
data is?
The same way that you know whether this message is in English."


what i meant was, is there a mysql function of some sort like what_language(field_value) to determine the type of data being stored? I know it might not sound logical, but i was just wondering if it's possible.


If i dump a database containing unicode using mysql dump, is there any difference from the plain old mysqldump?

how does mysql string functions work on unicode data, how would substring(unicode_data,0,3) work; php has a set of replacement string functions for unicode. They don't seem to work as expected, i tried with mysql 6 alpha.

I have tried mysql 6 alpha, its amazing that it can show unicode data as it is instead gibberish showed in the older versions, anybody happens to know what font they used in mysql 6 terminal to show unicode data?


thanks for your responses