Do you have a question? Post it now! No Registration Necessary. Now with pictures!
March 25, 2006, 5:14 am
rate this thread
I'm trying to order a column such that it's in order by pinyin, hence
an ORDER BY clause would change this:
I'm using UTF-8, and I've tried switching the collation on the column
to various UTF-8 collations and GBK and Big5, but no dice. ORDER BY
either doesn't order at all or orders by binary, which is also wrong.
I think what I need is a custom collation, and a very simple one at
that. It's basically the english alphabet plus 20 or so characters, in
UTF-8, case insensitive.
I have searched for "custom collation" to no avail, any pointers?
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum