Re: some questions related to Unicode
Hi,
>So, if i have multi lingual data, for example some records in chinese and some
>records in japanese, will setting collation to utf_general_ci, sort them
>correctly depending on the language?
The sorting will correctly depend on utf8_general_ci collation rules.
Nothing depends on 'language'.
>i have checked, i do not see any collation provided for devnagari scripts or
>indian languages. Is there one?
The ones that we list, e.g. ucs2_sinhala_ci, are the ones we have.
Sometimes people add their own collations.
>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.
Peter Gulutzan
MySQL / Sun
Subject
Views
Written By
Posted
3556
August 25, 2008 08:33PM
2524
August 26, 2008 03:23PM
2521
August 26, 2008 09:10PM
Re: some questions related to Unicode
2202
August 29, 2008 09:36AM
2385
September 01, 2008 09:38PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.