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> create table mychar(
-> id int auto_increment primary key,
-> mychar char(2));
Query OK, 0 rows affected (0.02 sec)
mysql> Insert into mychar values (null,'02');
Query OK, 1 row affected (0.00 sec)
mysql> select * from mychar;
+----+--------+
| id | mychar |
+----+--------+
| 1 | 02 |
+----+--------+
1 row in set (0.00 sec)
Did you insert data directly into MySQL database or using php/perl or
any other languages or tools?
Reoen> Dean-O
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
