MySQL a UTF-8

[Dalibor Straka]

On Mon, Nov 03, 2003 at 08:48:43AM +0100, Aben Siatris wrote:
> Dňa St 29. Október 2003 13:43 ste napísali:
> > On Tue, Oct 28, 2003 at 12:41:28PM +0100, Aben Siatris wrote:
> > > 
> > > A to niesu len tieto problemy, zaraza ma napriklad absencia alfa
> > > vstvy v Xfree, alebo nedostatocne unicode v MySQL, etc, etc, etc...
> > 
> > V MySQL verze 4.1.0-alpha je uz utf-8
> mam 4.0.16 a unicode sice je, ale nevie podla neho sortovat.
> vie 4.1.0 robit sort podla unicode?
> ked som naposledy pozeral ich stranku tak sa o nicom takom
> nezmienovali.
> 

AFAIK struktura souboru /usr/share/mysql/charsets/Index.xml vypada takto:
<charset name="latin2">
  <family>Central European</family>
  <description>ISO 8859-2 Central European</description>
  <alias>csisolatin2</alias>
  <alias>iso-8859-2</alias>
  <alias>iso-ir-101</alias>
  <alias>iso_8859-2</alias>
  <alias>iso_8859-2:1987</alias>
  <alias>l2</alias>
  <collation name="latin2_czech_ci" id="2" order="Czech" flag="compiled"/>
...

<charset name="utf8">
  <family>Unicode</family>
  <description>UTF-8 Unicode</description>
  <alias>utf-8</alias>
  <collation name="utf8"    id="33" flag="primary"/>
  <collation name="utf8_bin"    id="83" flag="binary"/>
</charset>

Zkuste do utf8 dopsat order="Czech". 

Hezky den,
-- Dalibor Straka