Results 1 to 3 of 3

Thread: Unicode support

  1. #1
    Join Date
    Jul 2003
    Posts
    3

    Unanswered: Unicode support

    Hi we are interested in knowing how to store and retrive our multilingual data in MySQL database. Can you please give us detaild information regarding
    it. Also if possible we want to know details about platform,language used
    etc... _ _
    In short we want unicode support in mysql.
    please anyone knows send me reply as soon as possible.
    Thanks in advance.
    Sam

  2. #2
    Join Date
    Jul 2003
    Posts
    35

    Re: Unicode support

    Originally posted by e_sharad
    Hi we are interested in knowing how to store and retrive our multilingual data in MySQL database. Can you please give us detaild information regarding
    it. Also if possible we want to know details about platform,language used
    etc... _ _
    In short we want unicode support in mysql.
    please anyone knows send me reply as soon as possible.
    Thanks in advance.
    Sam
    Hi Sam,

    Place the following in your /etc/my.cnf file:


    [mysqld]
    default-character-set=utf8


    and in your JDBC connection parameter list add:

    enableUnicode="true"
    characterEncoding="UTF-8"

    which will ensure you can write and retrieve UTF-8 encoded characters from the database. you may want to use the latest stable release of Connector J from MySQL... I think it is 3.0.8 from memory.

    That should work ok

    chrs.

  3. #3
    Join Date
    Jul 2003
    Posts
    35

    Re: Unicode support

    Originally posted by asherh
    Hi Sam,

    Place the following in your /etc/my.cnf file:


    [mysqld]
    default-character-set=utf8


    and in your JDBC connection parameter list add:

    enableUnicode="true"
    characterEncoding="UTF-8"

    which will ensure you can write and retrieve UTF-8 encoded characters from the database. you may want to use the latest stable release of Connector J from MySQL... I think it is 3.0.8 from memory.

    That should work ok

    chrs.
    oh yeah, i assume you are using MySQL 4.1 Alpha. Don't think Unicode is supported before that version.

Posting Permissions

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