Hi:
I’ve been having problems making php and mysql communicate with each other for a while. The problem specifically is characters that keep appearing because the character encodings are different.
can anyone tell me the exact steps i need to take to ensure this doesn’t keep happening. for example heres what i have:
1.
the encoding on the db seems to be: 65001 (UTF-8)
My Webpages are using the utf-8 charset.
[code]
<meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ />
After connecting to my db I set:
[code=php]
$this->query(“SET NAMES ‘utf8′”, $this->conn);
$this->query(“SET CHARACTER SET ‘utf8′”, $this->conn);
set my tables and fields to all use utf-8 encodings
I thought this would pretty much catch everything, however, when i:
[code=php]
echo mysql_client_encoding($this->conn) ;
i get: latin1
can anyone point me in the right direction to get my apps and db communicating correctly. Any webpages (i’ve looked) or any info is appreciated.
Thanks guys