Re: Any hints lantin1 utf-8

From: Date: Sat, 25 Nov 2006 05:00:02 +0000
Subject: Re: Any hints lantin1 utf-8
References: 1 2  Groups: php.db 
Request: Send a blank email to php-db+get-42750@lists.php.net to get a copy of this message
Hi I don't use phpMyAdmin myself and I can't remember if it supports UTF-8 encoding Whichever extension that your PHP is using is likely doing a conversion. this is something that the MySQL libraries handle. You can use this to extract the data from the tables and save it. As a test, dump a table's data into a file (have mysqldump, or phpMyAdmin create insert statements for the data). Create a table with UTF-8 encoding and attempt to process that file into it (copy/paste into phpMyAdmin if it's not to big) If that works, then you can go ahead and back up all your tables this way, and enter it into your new UTF-8 ones Without knowing more about your configuration (local/remote, versions, etc.) I can't suggest much else. Niel

« previous php.db (#42750) next »