Ken, That worked! THanks very much. > -----Original Message----- > From: Ken Menzel [mailto:[EMAIL PROTECTED]] > Sent: den 26 mars 2002 21:25 > To: Philip Semanchuk > Cc: [EMAIL PROTECTED] > Subject: Re: SELECT w/LIKE on Swedish character ö finds ], why? > > > 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
