Jump to content

[SOLVED] Inserting Special Characters to MySQL with php


briant

Recommended Posts

Alright, I don't know why all of a sudden inserting special characters into the DB isn't working. Maybe because I just changed host or different mysql version or something.

 

php ver: 5.2.5

mysql ver: 5.0.37

 

Well, I tried doing a simple insert. It inserts regular characters and pass but when it comes to French/Viet characters ie: âơù, it will come back with an error.

 

$sql = "INSERT INTO site SET name = 'Thùy'";

 

I've also tried changing the Collation from latin1_swedish_ci to utf8_bin but that didn't work.

 

Any help please?

 

Thanks

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.