Hi Philip, before running your test next time try this: vi /etc/my.cnf
insert into this file: [mysqld] default-character-set = swe7 then stop mysql (mysqladmin shutdown) and restart (safe_mysqld&) then try your test again. It worked fine for me. Ken > Philip Semanchuk wrote: > > > > 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. --------------------------------------------------------------------- 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