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
