Re: Exporting utf-8 data problems

mel list_php Wed, 04 Jan 2006 08:49:57 -0800

Hi,
Maybe your problem is linked to phpmyadmin?

I was having issues when trying to use an 'old' version (2.5.7) because theinterface itself of phpmyadmin was set up as iso-8859-1, and that wascausing all my data to be entered as isolatin even if the tables weredeclared as utf8.By updating to 2.6.4 I've been able to set up the language in phpmyadmin asen-utf-8, and now when I use this interface the data are actually utf8 inthe tables.

hth,
melanie

From: Dave M G <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: Re: Exporting utf-8 data problems
Date: Thu, 05 Jan 2006 00:54:44 +0900


        Thank you for the advice.

        In order to isolate the problem, I have checked to see if the text file
that I have exported from the MySQL server on my virtual host is, in
fact, in UTF-8.
        By opening it in OpenOffice and selecting UTF-8 encoding, it displays
correctly.
        Not entirely without problems. Most of the Japanese text shows up
correctly. But about 10% of it shows like this:
&#12503;&#12523;&#12539;&#12522;&#12540;&#12501;&#12391;
        I believe this is because there is probably some Japanese text that was
entered in sometime before the server upgraded MySQL to 4.1.
        But, ignoring the 10% of "legacy" text, it seems that at the very
least, I do have a proper UTF-8 encoded text file with which to import
into my home MySQL server.

        Instead of importing the data as an SQL file (which successfully
imported, but with faulty Japanese characters), I copied the text and
pasted them in as a straight SQL query.

        But it returns an error. Can anyone enlighten me as to why the file
would import into SQL as an SQL file, but the text won't work as an
import statement?

        Here is the error output:

SQL query:

# phpMyAdmin MySQL-Dump
# version 2.3.3pl1
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Jan 04, 2006 at 10:04 AM
# Server version: 3.23.37
# PHP Version: 4.3.11
# Database : `signup`
# --------------------------------------------------------
#
# Table structure for table `event_groups`
#
CREATE TABLE event_groups(

egid int( 11 ) NOT NULL AUTO_INCREMENT ,
GROUP int( 11 ) NOT NULL default '0',
event int( 11 ) NOT NULL default '0',
PRIMARY KEY ( egid )
) TYPE = MYISAM


MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'group int(11) NOT NULL default '0',
  event int(11) NOT NULL de

(the error message cuts abruptly, as shown here)

        Any advice would be much appreciated.

--
Dave M G


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


_________________________________________________________________

The new MSN Search Toolbar now includes Desktop search!http://toolbar.msn.co.uk/



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Re: Exporting utf-8 data problems

Reply via email to