Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Java > mysql error

Reply
Thread Tools

mysql error

 
 
terry
Guest
Posts: n/a
 
      08-18-2003
The following is a portion of my mysql script. When I run it, the line

INSERT INTO cat VALUES (16,'套餐',1);//error line

raises an error

outfile disabled

unknown command '\?

:
:
CREATE TABLE `cat`
(
`id` int unsigned NOT NULL auto_increment,
`name` text NOT NULL,
`catid` int,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
)
TYPE=MyISAM;
:
:
INSERT INTO cat VALUES (14,'炒飯',6);
INSERT INTO cat VALUES (16,'套餐',1);//error line

:
:

I have checked that the chinese character "餐" raise the error.
Do anyone know why and how to solve it?
 
Reply With Quote
 
 
 
 
Loic Minier
Guest
Posts: n/a
 
      08-18-2003
* terry <(E-Mail Removed)>,
18 Aug 2003 00:04:55 -0700:
> I have checked that the chinese character "餐" raise the error.
> Do anyone know why and how to solve it?


What is the encoding of your base? Wouldn't a mysql-newsgroup be more
adapted?


--
Loc Minier <(E-Mail Removed)>
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: How to insert PDF file in to MySql and read it from MySql toJAVA App Jeffrey H. Coffield Java 1 07-24-2009 12:29 AM
MySQL-python-1.2.2 install with no mysql washakie Python 4 01-15-2008 08:15 PM
"mysql.h: No such file or directory" when building MySQL-python francescomoi@europe.com Python 2 05-11-2005 03:12 PM
DBD:mysql doesn't read mysql option file /etc/my.cnf file JL Perl 0 01-28-2005 03:19 AM
"Pure Python" MySQL module like Net::MySQL Ravi Python 6 07-21-2003 06:53 PM



Advertisments