5 messages in com.mysql.lists.bugsRe: mysql (client) problem
FromSent OnAttachments
Remo Tex18 Nov 2005 01:44 
Peter J Milanese18 Nov 2005 01:47 
Remo Tex18 Nov 2005 01:50 
Remo Tex18 Nov 2005 02:01 
Remo Tex01 Dec 2005 02:32 
Subject:Re: mysql (client) problem
From:Remo Tex (id@remotex.bg)
Date:11/18/2005 01:50:02 AM
List:com.mysql.lists.bugs

Remo Tex wrote:

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

Same behavior with C:\mysql-5.0.15-win32\bin

C:\mysql-5.0.15-win32\bin>mysql -u admin -p Enter password: ******* Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 to server version: 5.0.15-nt-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select 'A\0A' as txt; +-----+ | txt | +-----+ | A | +-----+ 1 row in set (0.03 sec)

mysql> EXIT; Bye

but here shell=CMD.EXE prints out: space instead of '\0' C:\mysql-5.0.15-win32\bin>type zz.txt A A C:\mysql-5.0.15-win32\bin>