Ian,
I may be way off the mark here, but I've found MySQL usually starts quoting
the line from the place at which the error occurred, thus indicating it
didn't like the "insert" part. Not being able to see the preceding lines I
can only suggest it may not have an active database to write to.
When importing a mysqldump, make sure you specify the db name (I'm sorry if
this is too simplistic and obvious to you :-)
$ mysql dbname -u username -p < mysqldump.file
<provide password>
If this is not the case, and the contents of your database are not
sensitive, I'm willing to take a look and try it on my machine.
Hope this helps,
Ben
-----Original Message-----
From: Ian Corner [mailto:[EMAIL PROTECTED]]
Sent: 08 April 2001 22:32
To: [EMAIL PROTECTED]
Subject: character set works via web but not at command line?
Hi (if needed you can find my environment setup below)
I wish to load some data files at the mysql command prompt but seem to be
failing due to Swedish characters being incorporated. Here is the error:
ERROR 1064: You have an error in your SQL syntax near 'insert into category
(categoryid,description,xsectionid) values (
"HÓstar sÓljes"' at line 3
I was suprised as my web interface manages to place and retrieve Swedish
characters with no problems. Yet when I review table information at the
command prompt the Swedish characters are not visable.
Having read many messages and the "Languge" page in the document I still
have no answer as to why I can via the web, and why I cant via the data load
files?
I read a message dated early 2000 that compiling character sets was not
going to be need shortly as support for character sets was being developed.
Have I missed something?
I tried the "default-character-set" tag and I got an error that #10 was not
a compiled language? #10 being swe7 in the index file... and I figure
meaning Swedish. Whats happening and how do I resolve this.
In summary, I need to data load Swedish character files at the command line.
Thanks for any help.
Regards,
Ian
mySQL/Java environment -
os: w2000
mySQL server: v3.23.36
mySQL client: v3.23.33
IBM JVM 1.3
Web solution: JSP/Beans
Web server: Jakarta Tomcat (from Apache project)
Web JDBC: mm.mysql-2.0.4 and Poolman
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
