Re: mysql (client) problem

Silly, but did you try double \?



-----------------
Sent from my NYPL BlackBerry Handheld.


----- Original Message -----
From: Remo Tex [[email protected]]
Sent: 11/18/2005 04:45 AM
To: [email protected]
Subject: mysql (client) problem

mysql client doesn't print field contents after first '\0' character
e.g.:
mysql> select 'A\0AAAAAA' as txt;
+----------+
| txt      |
+----------+
| A        |
+----------+
1 row in set (0.00 sec)

but
/bin/bash would print 'A\0A' as AA

or let's check another way:
mysql> create table test (txt char(8));
Query OK, 0 rows affected (0.01 sec)

mysql> insert into test values ('AAAAAAAA'), ('A\0AAAAAA');
Query OK, 2 rows affected (0.00 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> select * from test;
+----------+
| txt      |
+----------+
| AAAAAAAA |
| A        |
+----------+
2 rows in set (0.00 sec)

mysql> status
--------------
mysql  Ver 12.22 Distrib 4.0.26, for pc-linux-gnu (i686)
...
Server version:         4.0.26-standard-log
Protocol version:       10
Connection:             Localhost via UNIX socket

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]