I think this is a bug
it seems it is reasonable since UNIX/C does consider back slash a
escape prefix for a sequence, in some case, it is not as nice as you think.
in multi-character set, back slash can be included in one of the
multi-characters.
I fix the problem by writing a VB program and a special handling in UNIX/C
program. Method is just to add another back slash whenever a back slash
is detected.
this is sure also a problem in load data, insert ...infile , etc commands.
let me say it another way
if there is a X sequence in UNIX/C
whenever "X" is encountered , you must add another "X" to it in order to
let the string normally insert into table, what do you think?
the problem is whether you think back slash can be part of a string.
FYI, database like oracle, informix, sybase all support multicharacter set
with back slash contained string support, consider it, please~
:)
Borus
----- Original Message -----
寄件者: "Benjamin Pflugmann" <[EMAIL PROTECTED]>
收件者: "Bruno Batarelo" <[EMAIL PROTECTED]>
副本: <[EMAIL PROTECTED]>
傳送日期: 2002年5月23日 AM 06:58
主旨: Re: Backslash BUG?
> Hi.
>
> Because the backslash is the escaping character and therefore has a
> special meaning, you have to escape it itself to get a plain
> backslash. I.e.
>
> mysql> insert into table (Field1) values ('\\');
>
> This will insert one backslash. This is documented here:
> http://www.mysql.com/doc/m/y/mysql.html
>
> The above statement is only true for the command line client and any
> other interface which uses backslash this way (e.g. C/C++ strings).
>
> Regards,
>
> Benjamin.
>
>
>
> On Wed, May 22, 2002 at 11:58:15PM +0200, [EMAIL PROTECTED]
wrote:
> > Greetings
> >
> > I use latest stabile version of MySQL. Please, try to create temp table
or
> > normal table and from mysql.exe try to insert a backslash symbol into a
> > field. Here is an example:
> >
> > Enter password: ******
> > Welcome to the MySQL monitor. Commands end with ; or \g.
> > Your MySQL connection id is 441 to server version: 3.23.49-max
> >
> > Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
> >
> > mysql> \u elba
> > Database changed
> > mysql> create temporary table TTable(Field1 mediumtext);
> > Query OK, 0 rows affected (0.04 sec)
> >
> > mysql> insert into ttable (Field1) values ('\');
> > '>
> > '>
> > '>
> > '>
> >
> >
> > That means that query ok message is skipped. The same problem occur if I
try
> > the same operation with blob data type. Please report me about this.
> >
> > Bruno
>
>
> --
> [EMAIL PROTECTED]
>
> ---------------------------------------------------------------------
> 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
