Saving UTF in sql via php - Help

[Tuck]

"-› ¿мαттнιαs? ‹-" is the string i set my sql db to be utf8_bin but well do  i have to replace some chars before saving it into sql i got str_replace() to replace ' with \' (this is just an example) could anyone show me :/

 

Saving it direct into database like that will be viewed correct with sql db viewer but, retrieving it with sql will display "-› ¿???????s? ‹-"

[MadTechie]

I'm not sure what your asking...

 

i have to replace some chars before saving it into sql i got str_replace() to replace ' with \'

 

Don't do a str_replace to replace ' with \',

use mysql_real_escape_string

 

$string = mysql_real_escape_string($string);
$query = "INSERT INTO `table` (`string`) VALUES ('$string')";

[cags]

I suspect the question should read something along the lines of "How do I succesfully store crylic characters in an SQL database? And how would I output this information?"

 

Have you checked the database with PHPMyAdmin to see if the characters appear correct? It's probable that the displaying isn't working properly because of the character encoding on the page your trying to echo the characters out to.

[Tuck]

I suspect the question should read something along the lines of "How do I succesfully store crylic characters in an SQL database? And how would I output this information?"

 

Have you checked the database with PHPMyAdmin to see if the characters appear correct? It's probable that the displaying isn't working properly because of the character encoding on the page your trying to echo the characters out to.

 

i tried to save them from phpmyadmin..

 

Read:

Saving it direct into database like that will be viewed correct with sql db viewer but, retrieving it with sql will display "-› ¿???????s? ‹-"

[cags]

So as I said the character encoding on the page isn't correct. You need to set the content type header, either by use of the header function or through HTML.

 

<meta http-equiv="content-type" content="application/xhtml+xml; charset=UTF-8" />

[MadTechie]

Cont. from cags

 

PHP option

header('Content-type: text/html; charset=utf-8');

 

[Tuck]

So as I said the character encoding on the page isn't correct. You need to set the content type header, either by use of the header function or through HTML.

 

<meta http-equiv="content-type" content="application/xhtml+xml; charset=UTF-8" />

 

now displays "-� �???????s? �-"

[Tuck]

 

now displays "-� �???????s? �-"

 

where it should be "-› ¿мαттнιαs? ‹-"

 

is there a prober way i should read it from sql?

[cags]

Check out this thread.

[Tuck]

I did a quick search and came across somebody that claims this solved their problem using...

 

mysql_query("SET CHARACTER SET utf8");
mysql_query("SET NAMES utf8");

 

... which is a slight addition to nrobi's suggestion.

 

$result = mysql_query("SELECT * FROM `lottery` WHERE `STEAM`='${LSTEAM}' AND `ID`>'1'");

 

show me an example how i would include it there? :/

[cags]

er....

mysql_query("SET CHARACTER SET utf8");
mysql_query("SET NAMES utf8");
$result = mysql_query("SELECT * FROM `lottery` WHERE `STEAM`='${LSTEAM}' AND `ID`>'1'");

 

[Tuck]

er....

mysql_query("SET CHARACTER SET utf8");
mysql_query("SET NAMES utf8");
$result = mysql_query("SELECT * FROM `lottery` WHERE `STEAM`='${LSTEAM}' AND `ID`>'1'");

 

though u ment it needed to be included in the mysql_query of result ;/ trying it now

[MadTechie]

Personally i have

mysql_query("SET CHARACTER SET utf8");
mysql_query("SET NAMES utf8");

on the same place as connection to the database

[cags]

Personally i have

mysql_query("SET CHARACTER SET utf8");
mysql_query("SET NAMES utf8");

on the same place as connection to the database

 

Yer, that would obviously be more sensible than before each query. I wasn't intending to be literal.

[MadTechie]

LOL, I kinda guess your know cags, it was more a comment for Tuck