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
