-Original Message-
From: [EMAIL PROTECTED]
To: Rochester, Dean
Sent: 4/3/02 4:26 PM
Subject: Re: How can I set a char(2) column to always stay 2 chars?
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must
Rochester,
Thursday, April 04, 2002, 3:39:41 PM, you wrote:
Reoen I have a table with a char(2) and when I send it '02' I want it to stay
Reoen 02,
Reoen but instead it stores 2
Reoen How do I make this store as '02'?
If you have char column your data will be stored as a string.
Look:
mysql
Hi Dean,
I have a table with a char(2) and when I send it '02' I want it to stay
02,
but instead it stores 2
How do I make this store as '02'?
Works for me:
mysql create table t ( a char(2) );
Query OK, 0 rows affected (0.08 sec)
mysql insert into t values ('02');
Query OK, 1 row