At 3:25 PM -0700 6/8/01, Dong Wang wrote:
>It seems that MySQL is removing ending spaces in the insert statements.
>
>mysql> create table temp (c1 varchar(10));
>Query OK, 0 rows affected (0.08 sec)
>
>mysql> insert into temp values ('a ');
>Query OK, 1 row affected (0.00 sec)
>
>mysql> select concat(c1, "***") from temp;
>+-------------------+
>| concat(c1, "***") |
>+-------------------+
>| a*** |
>+-------------------+
>1 rows in set (0.00 sec)
>
>How can I preserve the ending space?
Use BLOB or TEXT for your column datatype, not VARCHAR.
What's your DBI question? :-)
>
>
>> Dong Wang
>> Grand Central Networks
>> [EMAIL PROTECTED]
--
Paul DuBois, [EMAIL PROTECTED]
