mysql (client) problem
Remo Tex <[email protected]> Fri, 18 Nov 2005 11:45:08 +0200
| Newsgroups | gmane.comp.db.mysql.bugs |
|---|---|
| Message-ID | <[email protected]> |
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]