Dear Rsaras,
your problem description is not very precise.
>message.Then i try to change the type to char ,it's can but,
>the max is until 9 only.is there anyone can help me.
I guess what you did was to add a field with CHAR type to your table. If
you do not specify the length, like CHAR(20), the length will be set to
1 (so that's CHAR(1)). This will hold only one digit, and that's 0 to 9.
Regards,
--
Stefan Hinz
Geschäftsführer / CEO iConnect e-commerce solutions GmbH
# www.js-webShop.com www.iConnect.de
# Gustav-Meyer-Allee 25, 13355 Berlin
# Tel: +49-30-46307-382 Fax: +49-30-46307-388
----- Original Message -----
From: "rsaras" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 08, 2001 5:08 AM
Subject: integer & char
hai ,
i have a problem in query. My field type is integer.
The table is empty and i want to select max number from the field but
it display error message.Then i try to change the type to char ,it's can
but,
the max is until 9 only.is there anyone can help me.
thanks in advance
---------------------------------------------------------------------
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
