|
|
Posted by Juliette on 07/25/06 04:33
J.O. Aho wrote:
> Stabby wrote:
>> Using PHP 5.1.4 with MySQL 5.0.18 on a dev machine. Doesn't seem to
>> matter what I do, character encoding is screwed on this server. It's
>> ok with normal chars, but "extended" chars like the pound sign (£) are
>> corrupted when sent to the DB from a form then back to the browser
>> from the DB. I'm setting the following headers on the top of every
>> page (using an include, so I'm certain it's always in there):
>
> Writable characters (<=127) in the different character setups are are in
> most cases exact the same, but the extended (>=128) may have big
> differences.
>
> The database should be set to support utf8, enter in the mysql client
> prompt:
> SHOW CHARACTER SET;
>
>
>> <?xml version="1.0" encoding="utf-8"?><!DOCTYPE html PUBLIC
>> "-//W3C//DTD XHTML 1.0 Transitional//EN"
>> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
>> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"
>> dir="ltr">
>>
>> Also using header("Content-type: text/html; charset=ISO-8859-1"); in
>> the include file for good measure. PHP scripts are being saved in UTF8
>> encoding. Server is running Linux.
>
> If the files are saved as utf-8 and your apache is set to send out
> iso-8859-1 (see your apache config), then you get troubles.
>
> http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html
>
>
>
> //Aho
This page may also help you to find the problem as it covers some common
problems with character encoding :
http://adviesenzo.nl/examples/php_mysql_charset_fix/
Navigation:
[Reply to this message]
|