From: Arjen Lentz
Date: May 6 2009 9:59pm
Subject: Re: Loss of HTML Graphics Characters
List-Archive: http://lists.mysql.com/community/329
Message-Id: <136F2065-DDEA-424C-AD8B-1C8E08DB388E@lentz.com.au>
MIME-Version: 1.0 (Apple Message framework v930.3)
Content-Type: text/plain; charset=WINDOWS-1252; format=flowed; delsp=yes
Content-Transfer-Encoding: quoted-printable

Hi Hamid,

On 07/05/2009, at 2:17 AM, Hamid Majidy wrote:
> Hello MySQL community. I have MySQL 5.0.45 with Apache 2.2.3 running =20=

> on
> CentoOS 5.2 with a page display issue. Pages display as:
> =C2 =C2 =C2 =C2 Model=C2 =C2 =C2 =C2 =C2 =C2
> [...]


> Ihave changed DB collation to latin1_swedish_ci on former to match the
> latter DB table=92s collation setting. All database and table settings =
=20
> through
> phpAdmin appear identical, yet the two HTML pages rendered on the same
> Windows client machine running the same instance of Firefox appear
> different. I have even dumped the entire table structure and =20
> contents from
> one and imported to the other with the same result. HTML contents of =20=

> the 2
> fields have to be identical after the import. Restarting apache and =20=

> mysql
> after all the changes did not help either.


Collation has to do with sorting.
What you need to check out is character set (usually utf8 or latin1).

if you are using utf8, you should use something like utf8_general_ci =20
as the collation also.
But most importantly, your PHP connection should first set "SET =20
NAMES=3Dutf8" as soon as it connects, before doing anything else.
That'll make the connection use utf8 properly without mangling stuff =20
that comes out of the db.

Then, there's the character set indicator of your HTML pages =20
themselves, a HTML page can indicate which charset it's using; check =20
that also.


Cheers,
Arjen.
--=20
Arjen Lentz, Director @ Open Query (http://openquery.com)
Affordable Training and ProActive Support for MySQL & related =20
technologies

Follow our blog at http://openquery.com/blog/
OurDelta: free enhanced builds for MySQL @ http://ourdelta.org