I have the same problem with Greeks, it is a bug of MySQL.
Try:
1) Create the fields of the table with BINARY option.
2) Use LIKE with BINARY option (slower)
BINARY doesn't make the uppercase convertion.

Makis


> -----Original Message-----
> From: Philip Semanchuk [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, March 26, 2002 6:45 PM
> To: '[EMAIL PROTECTED]'
> Subject: SELECT w/LIKE on Swedish character ö finds ], why?
>
>
> Hi everyone,
> I am having a little trouble with searching for Swedish characters. When I
> SELECT using LIKE I get matches that I do not expect. I have created a
> simple test case that is entirely reproduced below. To summarize, I insert
> one row into a single-column table that contains the right square bracket
> character (ASCII 0x5d). When I search for the Swedish letter ö (ISO-8859-1
> 0xf6) I find the row containing the right bracket.
>
> We're running RedHat 7.2 with nothing fancy added in as we're
> Linux novices
> and just playing around with the system to see how it works. MySQL -V
> produces this:
> mysql  Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
>
> Here's my test:
>
> mysql> create database swedish_character_test;
> Query OK, 1 row affected (0.00 sec)
>
> mysql> use swedish_character_test;
> Database changed
> mysql> create table simple (name varchar(255) NOT NULL);
> Query OK, 0 rows affected (0.00 sec)
>
> mysql> insert into simple (name) values (']');
> Query OK, 1 row affected (0.00 sec)
>
> mysql> select name from simple where name like '%ö%';
> +------+
> | name |
> +------+
> | ]    |
> +------+
> 1 row in set (0.00 sec)
>
>
> I'd appreciate any help understanding why ö = ] in this case.
>
> Thanks in advance,
> Philip
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to