Mysql insert problem! (UTF8 characters don't show)

Discussion in 'PHP' started by Make a perfect site, Jul 28, 2011.

0
  1. #1
    I have a form which is submitted into a mysql database. The database is set to UTF-8_GENERAL and the rows are using the same character coding as well.

    But when I submit the form with a "ő" or "ű" in the text, it does not submit anything after these characters. (Example: "This is a nice ű day." It just inserts this into the db: "This is a nice")

    The form validation page has the mysql_real_escape_string(); strip_tags(); before submitting to the db.

    I echo out the result after every string function (mentioned above). It all works fine, but when it gets inserted, it doesn't display anything after those characters.

    [MySql version: 5.0.51a-24+lenny5-log | Using phpMyAdmin version: 2.11.8.1deb5+lenny7]

    How could I solve this? Any help appreciated...
     
    Make a perfect site, Jul 28, 2011 IP