Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    2

    Unanswered: Help Encoding Characters in mySQL

    Ive just upgraded mySQL on my server from a very old system to the latest and now Im finding it strips out characters when they are greater than ASCII 127. This new version has something called Collation that I have never encountered before. I think mine is set to utf8_general_ci. Anyway, here is my query that Im using in PHP to add data to my DB:

    PHP Code:
    INSERT INTO 'mytable' (messageVALUES ('$message'
    It use to work fine before but now with the new version of mySQL, its faling when I add special charecters as those listed below

    Hello World
    Accented VVVVV
    Apostrophe 1 "" WWWW
    Apostrophe 2 '' XXXXX
    Apostrophe 3 YYYYY
    Apostrophe 4 ZZZZZ
    The quick brown fox kicks the butt of the lazy dog
    Now, if I add the above text in to the DB, only the following gets inserted:

    Hello World
    Accented
    As the DB removes all of the special characters.
    Can anyone advise me?

    Im not a mySQL expert and these pages are not helping:
    http://dev.mysql.com/doc/mysql/en/Charset.html
    http://dev.mysql.com/doc/mysql/en/Charset-CONVERT.html

    Any advice will be much appreciated.
    Thank you kindly.

  2. #2
    Join Date
    Nov 2004
    Posts
    2
    Anyone?  

Posting Permissions

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