RE: SELECT w/LIKE on Swedish character ö finds ], why?

2002-03-28 Thread savaidis
: 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

Re: SELECT w/LIKE on Swedish character ö finds ], why?

2002-03-28 Thread Ken Menzel
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

RE: SELECT w/LIKE on Swedish character ö finds ], why?

2002-03-27 Thread Philip Semanchuk
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

RE: SELECT w/LIKE on Swedish character ö finds ], why?

2002-03-26 Thread savaidis
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]]

Re: SELECT w/LIKE on Swedish character ö finds ], why?

2002-03-26 Thread James Housley
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

RE: SELECT w/LIKE on Swedish character ö finds ], why?

2002-03-26 Thread Philip Semanchuk
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

RE: SELECT w/LIKE on Swedish character ö finds ], why?

2002-03-26 Thread Philip Semanchuk
]' 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

Re: SELECT w/LIKE on Swedish character ö finds ], why?

2002-03-26 Thread Ken Menzel
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