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