> I get incorrect result when searching for the norwegian character 'å'
> using LIKE. I get rows with 'a' in it, and visa versa if I search for
> 'a', I get results which has 'å' in it in addition to the ones with 'a'.
Make sure that your table has:
charset=utf8
collation=utf8_norwegian_ci
A
Dear List,
I get incorrect result when searching for the norwegian character 'å'
using LIKE. I get rows with 'a' in it, and visa versa if I search for
'a', I get results which has 'å' in it in addition to the ones with 'a'.
Example:
CREATE TABLE names (
name VARCHAR(255)
)ENGINE=InnoDB DEFA
: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
> -Original Message-
> From: John Trammell [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 24, 2007 10:30 AM
> To: Critters; MySQL General
> Subject: RE: Problem with characters
>
> > From:
> From: Critters [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 24, 2007 5:24 AM
> To: MySQL General
> Subject: Problem with characters
>
> I have a new setup with mySql version 4.1 and myODBC version 3.51
> running on Windows 2k3 standard
>
> In the database we ha
; Sent: Monday, September 24, 2007 5:24 AM
> To: MySQL General
> Subject: Problem with characters
>
> I have a new setup with mySql version 4.1 and myODBC version 3.51
> running on Windows 2k3 standard
>
> In the database we have something like "And this is £200" and when w
I have a new setup with mySql version 4.1 and myODBC version 3.51
running on Windows 2k3 standard
In the database we have something like "And this is £200" and when we
write this out in ASP we get "And this is ?200" The same happens for
some other symbols like the copy write symbol (c in a cir
