UTF8 text encoding and php with mysql

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
topcattony
Forum Newbie
Posts: 1
Joined: Tue Feb 16, 2010 3:45 am

UTF8 text encoding and php with mysql

Post by topcattony »

Hi,

I have an annoying problem when migrating data from a database to another. The data in the original database is all encoded as Latin1 and the collation on the db and all the tables and text fields is Latin1 throughout. However when you view the data on the website that is connected to it it displays as UTF8 ie it has characters such as řčšěáí etc.

When I check the tables using phpmyadmin, the data does nost display correctly, I am guessing that the data is being converted from Latin1 to UTF8 by the php code in the website backend, does anyone know how this is done?
Post Reply