[SOLVED] Inserting Special Characters to MySQL with php

[briant]

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

[Wuhtzu]

May we please have the error?

[briant]

Basicly I added this error:

 

if (!mysql_query($sql)) die("ERROR");

[revraz]

if (!mysql_query($sql)) die("ERROR" .mysql_error());

[briant]

Oh thanks, here is the error:

 

Incorrect string value: '\xF9y Tra...' for column 'name' at row 1

[revraz]

Do you get a UTF-16 option?

[briant]

Nope, only UTF-8.

 

I don't think it has anything to do with the collation since it worked before with latin1_swedish_ci.

[crashmaster]

try: to find special chars of Swedish alphabet in UTF-8 table... for example: ý =  ý 

And than use string replace, to prevent it

[revraz]

Not sure if this helps

 

When you create the table,

 

set session collation_database=latin1_swedish_ci;

set session character_set_database=latin1;

 

[briant]

Oh I'm sorry guys. Thanks for all the support. It was a template problem that didn't support special characters. Nothing related to mysql. Works well now, sorry, and thanks again for the help.