Re: set names 'utf8'
Posted by: Suat Ural
Date: November 20, 2007 06:04AM

I want to execute a UTF8 w/o BOM sql file and get the following:
___________________________________
ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the ma
nual that corresponds to your MySQL server version for the right syntax to use n
ear '´╗┐
DROP TABLE IF EXISTS banner' at line 1
______________________________________

If it is related to I have also executed set names 'utf8' before sql execution but it did not work.
Is there a simple way other than shell to execute large utf8 sql files.

Options: ReplyQuote


Subject
Views
Written By
Posted
68001
September 29, 2005 02:30AM
21548
September 30, 2005 02:54AM
48900
September 30, 2005 11:45AM
15664
October 04, 2005 02:52PM
Re: set names 'utf8'
15645
November 20, 2007 06:04AM
12792
February 14, 2009 09:18AM


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.