Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    India
    Posts
    109

    Unanswered: Problem handling non-ascii characters!!

    Hi,

    I am working on a product that requires internationalisation. I maintain separate language files for each and every language and use UTF-8 encoding.

    My HTML meta tags use UTF-8 format. For the database, I use
    Code:
    SET CHARACTER SET utf8
    as my first query after connecting to the database.

    While this works great for some characters (german), it doesn't for russian. Russian characters work fine only if I do not execute this query.

    Could anyone please let me know the procedure to follow when one works on a project that will have multiple language data?

    I have done the below till now.

    1) HTML meta tags -> UTF8
    2) Incoming and outgoing mails -> utf-8 encoded and decoded.
    3) Mysql -> set character set=utf8

    What else do I need to do?

    Thank you in advance!
    Last edited by rexselin; 01-27-07 at 09:32.

  2. #2
    Join Date
    Aug 2003
    Location
    India
    Posts
    109
    Well, I solved the problem. My database had latin1 character set and hence didn't work well with languages that needed more bytes.

    To fix the problem, create database using utf8 encoding.

Posting Permissions

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