Hi, my name is Francesca and I've a problem with the space character using mysql.
I try to explain the problem in a way similar to mysqldebug.txt. m: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Problem updating a CHAR(1) columns whith a space character. Description: I have a table with a CHAR(1) column. When i try to insert a space charcacter (' ') in this column I haven't an error but the column not contains ' '; I'm not able to insert this character. I read in the html manual that for VARCHAR columns, trailing spaces are removed when the value is stored. The same thing happens with CHAR?. There is the possibility to insert this value or not? How-To-Repeat: I try to explain my problem describing the table and the statements that I try to execute with mysql. In order to create table I use this statement: CREATE TABLE ANTI_MNY_LNDRY_RESN ( C_INST int(2) NOT NULL, C_ANTI_MNY_LNDRY_RESN CHAR(1) NOT NULL ); To insert a row: INSERT INTO ANTI_MNY_LNDRY_RESN (C_INST, C_ANTI_MNY_LNDRY_RESN) VALUES(1,' '); The statement was executed with success (Query OK, 1 row affected (0.00 sec)) but the char inserted in column is '' and not ' '. Originator: Francesca Sandrini Organization: DS DataSystems MySQL support: none Severity: non critical Priority: medium Category: mysql Class: support Release: mysql-3.23.38 System: Windows 2000 Thanks a lot in advance, Francesca --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php