Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Posts
    12

    Unanswered: Accents & special characters

    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

  2. #2
    Join Date
    Feb 2001
    Location
    NC, USA
    Posts
    200
    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.

  3. #3
    Join Date
    Feb 2002
    Posts
    12
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •