Search code examples
mysqldatabaseutf-8type-conversionlatin1

Datas from mysql database don't display on website

I started my Project with UTF8 Database for the development. At the time of project completion, my Professor gave me the database of type Latin1. Because of Type Conflicting my project is not working properly, result my server side code doesn't access the database.

I tried much conversion: My Professors database into UTF8, but it failed. Still I’m facing the issue. Kindly assist me in this regards.

Thank you !

Solution

  • You may try a charset converter like MySQL charset converter

    This PHP script can be used to convert your MySQL database tables from latin1-to-UTF8 while retaining the integrity of all internal multibyte characters.