www.webdeveloper.com
Results 1 to 3 of 3

Thread: Retrieving unicode data saved in MySQL with collation ucs2_unicode_ci

  1. #1
    Join Date
    Sep 2004
    Location
    Sri Lanka
    Posts
    470

    Question Retrieving unicode data saved in MySQL with collation ucs2_unicode_ci

    Hi,

    I had troubles with saving Sinhalese characters in to MySQL and was able to overcome those by defining MySQL collation as ucs2_unicode_ci . That works fine.

    However when data is retrieved and printed on web page, i do only get question marks instead of Sinhalese UNICODE characters. I tried with changing document charset to UCS-2, UTF-16 etc, still the result is same. All UNICODE Sinhalese characters which are hard coded are displayed without an issue. I have trouble with only ones loaded from database.

    It would be a great help if you could please suggest me a fix for this.

  2. #2
    Join Date
    Aug 2004
    Location
    Ankh-Morpork
    Posts
    19,359
    Here's the info I've collected on the subject (a bit dated, but I think it's still good): http://www.charles-reace.com/blog/20...php-and-mysql/
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    eBookworm.us

  3. #3
    Join Date
    Sep 2004
    Location
    Sri Lanka
    Posts
    470

    Thanks

    Quote Originally Posted by NogDog View Post
    Here's the info I've collected on the subject (a bit dated, but I think it's still good): http://www.charles-reace.com/blog/20...php-and-mysql/
    Thanks for your guidance.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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



Recent Articles