Skip navigation links

MySQL Forums :: PHP :: Encoding problem...


Advanced Search

Re: Encoding problem...
Posted by: Ted Ashton ()
Date: August 05, 2010 12:37AM

Hi,

Finally, running the query 'SHOW variables Like '%char%';' on the local server reveals:

character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_filesystem binary
character_set_results utf8
character_set_server utf8
character_set_system utf8
character_sets_dir /usr/local/mysql-5.1.38-osx10.5-x86/share/charsets/


and on the remote server:

character_set_client utf8
character_set_connection utf8
character_set_database latin1
character_set_filesystem binary
character_set_results utf8
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/share/mysql/charsets/


Running 'SHOW CREATE DATABASE `dbDixon100620`;' on the local server shows:

CREATE DATABASE `dbdixon100620` /*!40100 DEFAULT CHARACTER SET utf8 */

and on the remote server:

CREATE DATABASE `times_dbDixon` /*!40100 DEFAULT CHARACTER SET latin1 */


Also, the top of the dump file contains the following:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


Many thanks,

Chris

Options: ReplyQuote


Subject Written By Posted
Encoding problem... Teddy Ashton 07/30/2010 07:04AM
Re: Encoding problem... Guelphdad Lake 07/30/2010 07:43AM
Re: Encoding problem... Rick James 08/01/2010 02:33PM
Re: Encoding problem... Ted Ashton 08/04/2010 02:53PM
Re: Encoding problem... Ted Ashton 08/04/2010 02:59PM
Re: Encoding problem... Teddy Ashton 08/02/2010 11:52AM
Re: Encoding problem... Ted Ashton 08/02/2010 06:10PM
Re: Encoding problem... Rick James 08/02/2010 08:42PM
Re: Encoding problem... Ted Ashton 08/05/2010 12:30AM
Re: Encoding problem... Ted Ashton 08/05/2010 12:33AM
Re: Encoding problem... Ted Ashton 08/05/2010 12:35AM
Re: Encoding problem... Ted Ashton 08/05/2010 12:37AM
Re: Encoding problem... Rick James 08/05/2010 08:43AM
Re: Encoding problem... Ted Ashton 08/06/2010 02:17PM
Re: Encoding problem... Rick James 08/06/2010 11:01PM
Re: Encoding problem... Ted Ashton 08/08/2010 04:01PM
Re: Encoding problem... Rick James 08/08/2010 06:16PM
Re: Encoding problem... Ted Ashton 08/05/2010 12:40AM
Re: Encoding problem... onokung onokung 09/01/2010 12:53PM
Re: Encoding problem... Rick James 09/01/2010 10:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.