MySQL is doing the right thing, \' will mean single-quote character, so you will have to close it with another one. If you want to enter just a backslash do '\\' .
See: http://www.mysql.com/doc/S/t/String_syntax.html Gurhan -----Original Message----- From: Bruno Batarelo [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 22, 2002 5:58 PM To: [EMAIL PROTECTED] Subject: Backslash BUG? 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 --------------------------------------------------------------------- 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