MySQL cuts off string at special chars

Question

I'm trying to insert remote POST data (articles sent by iSnare) into MySQL with PHP. Data comes successfully from remote POST sender and I can write it to plain-text file without a problem. Unfortunately, when it comes to insert it into MySQL, MySQL cuts off string (article) at special char. I tried many things but still I'm unsuccessful! I tried: - Escaping chars with `mysql_real_escape_string()` - Using `htmlentities()` and `htmlspecialchars()` (with every parameter..) - Sending `SET NAMES utf8` query to MySQL before doing everything else - All tables and columns are UTF-8 encoded and `utf8_general_ci` (also tried `utf8_unicode_ci` and `utf8_bin` as collation) - Saving all PHP files as UTF-8 Still I couldn't find the solution. I will appreciate it very very very much if someone can help me solve this problem. Here is my table definition and PHP codes: PHP ``` function guvenlik_sql($x){ // Cleans inputs agains sql injection return mysql_real_escape_string(htmlentities(stripslashes($x…

Accepted Answer

I've just dealt with the same situation, entries were cut off where the special character (ä, ö, è, etc) supposed to be. All my files are UTF8 encoded, the connection is UTF8 encoded, table collations are UTF8, still the entries were cut off.

My solution was: even more UTF-encoding! :) Use `utf8_encode()` on the entries which can contain special characters.

```
mysql_query("INSERT INTO articles (first_name, email, title, description, article, article_html, category, resource_box, resource_box_html, keywords, distributor, distributor_host) values (
                                  '" . utf8_encode($first_name) . "',
                                  '" . $email . "',
                                  '" . utf8_encode($title) . "',
                                  '" . utf8_encode($description) . "',
                                  // etc
```

MySQL cuts off string at special chars

Solution

Problem

Related problems