dave I believe group is a reserved word. change to grp.
david -----Original Message----- From: Dave M G [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 04, 2006 8:55 AM To: mysql@lists.mysql.com Subject: Re: Exporting utf-8 data problems 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: プル・リーフで 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
