Hi Makis, default-character-set = greek Try that, best wishes, Ken
P.S. also for anyone else asking here are all the charsets included in MySQL by default. You can also create your own. mysql> show variables like "char%"; +----------------+---------------------------------------------------- ---------------------------------------------------------------------- ---------------------------------+ | Variable_name | Value | +----------------+---------------------------------------------------- ---------------------------------------------------------------------- ---------------------------------+ | character_set | latin1 | | character_sets | latin1 dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr greek win1250 croat cp1257 latin5 | +----------------+---------------------------------------------------- ---------------------------------------------------------------------- ---------------------------------+ 2 rows in set (0.00 sec) ----- Original Message ----- From: "savaidis" <[EMAIL PROTECTED]> To: "Ken Menzel" <[EMAIL PROTECTED]>; "Philip Semanchuk" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, March 28, 2002 12:40 PM Subject: RE: SELECT w/LIKE on Swedish character ö finds ], why? > Is there something similar for Greeks too? > (not that matters very much as I run on internet host but in case..) > > > Makis > > > > -----Original Message----- > > From: Ken Menzel [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, March 26, 2002 10:25 PM > > 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 > > > > > -------------------------------------------------------------------- - > 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