: 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
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
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
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]]
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
THanks Makis, is this bug documented anywhere?
-Original Message-
From: savaidis [mailto:[EMAIL PROTECTED]]
Sent: den 26 mars 2002 18:04
To: Philip Semanchuk; [EMAIL PROTECTED]
Subject: RE: SELECT w/LIKE on Swedish character ö finds ], why?
I have the same problem with Greeks
]'
Subject: Re: SELECT w/LIKE on Swedish character ö finds ], why?
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
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