Re: Subj: MySQl and Unicode support

From: Henrik Theiling (
Date: Thu Feb 22 2007 - 09:03:24 CST

  • Next message: Ed Trager: "Re: Subj: MySQL and Unicode support"


    Philippe Verdy writes:
    > Note that sorting (SELECT... ORDER BY...) may be an issue if you expect the
    > results from the database to be in the appropriate order; ...

    Erm, MySQL has quite good support for sorting UTF-8 strings in results
    of SELECT queries. I'm using that without problems. E.g. you can
    assign a charset and a collation to each string in a record and
    override that in the queries. It also supports conversions between
    charsets (storing in UTF-8, displaying on a Latin-1 terminal (if
    possible), etc.). I'd call that Unicode aware -- it goes much beyond
    transparently storing 8-bit strings.

    IIRC, however, MySQL currently only supports code positions up to
    U+FFFF, i.e., only 16 bits which I personally find a bit annoying.
    Let's hope they'll fix that in future versions.


    This archive was generated by hypermail 2.1.5 : Thu Feb 22 2007 - 09:05:28 CST