> 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: