> Entering it in hex works for me too. So the problem _was_ actually with
> the values I inserted into the database.
>
> What's the best way to actually see what is stored in the database,
> preferably as hex or something else that a terminal is guaranteed to
> display correctly? Clearly, what
On Tue, Aug 03, 2004 at 01:11:44PM -0400, Jeremy March wrote:
> Is this for Swedish language data? I don't know Swedish so I don't
> actually know where u-diaeresis is sorted in Swedish myself, but
> according to the source code (in the file: strings/ctype-uca.c) the
> u-diaeresis is sorted as an
>...
> mysql> SELECT col2 FROM test ORDER BY col2 COLLATE utf8_swedish_ci;
> ++
> | col2 |
> ++
> | M(u-diaresis)ller |
> | Muffler|
> | MX Systems |
> | MySQL |
> ++
> ...
> I expect M(u-diaeresis)ller to sort after MX Systems in the following:
I am attempting to use the new UTF8 collations in MySQL 4.1.3 to perform
case-insensitive, accent-insensitive sorting. Based on the example in
section 11.3.13 of the manual
(http://dev.mysql.com/doc/mysql/en/Charset-collation-effect.html )
I expect M(u-diaeresis)ller to sort after MX Systems in t