Re: mysql (client) problem

Of course Peter ...without success
( probably my mistake : try instead
select CHAR(65,0,65) as txt;
I want it to show AA or A A like /bin/bash and CMD.exe does )

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

That's still not what I want - I want it to be actually CHAR(0) at this 
position [representing array of strings \0 separated and \0\0 at end - 
don't ask why :) ] then I want to see rest of the field i.e. other strings
like e.g.: /bin/bash would show  AA and CMD.EXE -> A A
I just want to see rest of the field contents

P.S. I think that's implementation specific [why they choose C/C++, 
AFAIK Pascal doesn'h have such problems?!? - jist a joke :) ] but pretty 
easy to fix...

Peter J Milanese wrote:
> 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]