Problems with special characters and MySQL

Asked May 14 '17 at 08:48

Active May 14 '17 at 08:56

Viewed 18 times

I have problems adding values to a text column as soon as "special characters" are used, like inside Ligat ha'Al. I am using php to send variables into my database. Are there any ways to "clean" this variable or convert the characters to avoid errors when submitting the data? The column in my database is utf8_unicode_ci.

I have added $conn = new PDO("mysql:host=$servername;dbname=$dbname;charset=utf8", $username, $password);, but the error still exists.

Please help! Thanks for that!

edited May 14 '17 at 08:56

asked May 14 '17 at 08:48

Robin Alexander

@Strawberry I have add the charset as shown in https://stackoverflow.com/questions/279170/utf-8-all-the-way-through, but that is not working – Robin Alexander May 14 '17 at 09:25
Which operating system – Strawberry May 14 '17 at 09:28
No idea, Sorry. – Robin Alexander May 14 '17 at 09:35

Problems with special characters and MySQL

0 Answers0