: 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
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
: Tuesday, March 26, 2002 6:45 PM
To: '[EMAIL PROTECTED]'
Subject: SELECT w/LIKE on Swedish character ö finds ], why?
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
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