Accents & special characters

crighton · #1 (**permalink**) 02-24-02, 00:33

Hi,

Is the recognition of accents and special characters a user-setting in MySQL?

On my local developement version of a current project I can search for "miro" and it returns a result (correctly) for Joan Miró. On the identical version of the site hosted at the clients ISP the same search returns no results (as I assume it expects the accent).

Is there anything I can do to get around this?

Gary

Paul · #2 (**permalink**) 02-24-02, 12:21

MySQL does have options to add additional character sets during the configure stage when compiling and the default is Latin 1. I believe the binary distributions are compiled with all character sets.

Not sure how these additional character sets are actually used though. These forums are using MySQL compiled with just Latin1 and I see all the accents etc.

crighton · #3 (**permalink**) 02-24-02, 13:38

Hi Paul,

Thanks for the response and I guess I'll have to delve into this one a little further. Seems odd though that the behaviour differs between the local copy and the www copy of the site...

Cheers,

Gary