Re: mysql (client) problem

C:\mysql-5.0.16-win32\bin\mysql.exe
...still no progress :(

as per manual: "...When CHAR values are retrieved, trailing spaces are 
removed. No lettercase conversion takes place during storage or 
retrieval.", so: what about non-trailing non-space characters like '\0' 
e.g.:
select CHAR(65,0,65,66,67) as txt;
so... seems server cuts just trailing (spaces), then client cuts even 
more i.e. not just 1 char but everything after that '\0' ..and what's 
left :(
---
  - I'll take right (one).
  - Then ...I'll take what's left.
  just a joke :)

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

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