Tux rules!

Recent News

Join the
ILUG
on FaceBook

Join the
ILUG
on LinkedIn

Join the
ILUG SETI
Group

:: Mailing Lists

[Webdev] MySQl & Leading zero's

[Webdev] MySQl & Leading zero's

Donncha O Caoimh donncha.ocaoimh at tradesignals.com
Wed Jun 14 16:43:12 IST 2000

Previous message: [Webdev] MySQl & Leading zero's
Next message: [Webdev] MySQl & Leading zero's
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

If you want to store the leading zeros you're not strictly storing the
numbers as integers anymore.
CHAR type sounds like the right field type to use to me.

Donncha.


Dave Burke wrote:
> 
> howya!
> 
> Is there anyway to stop mysql from chopping out the leading zero's from a
> bigint field?
>

Previous message: [Webdev] MySQl & Leading zero's
Next message: [Webdev] MySQl & Leading zero's
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

More information about the Webdev mailing list
Read this without the formatting.

Maintained by the ILUG website team. The aim of Linux.ie is to support and help commercial and private users of Linux in Ireland. You can display ILUG news in your own webpages, read backend information to find out how. Networking services kindly provided by HEAnet, server kindly donated by Dell. Linux is a trademark of Linus Torvalds, used with permission. No penguins were harmed in the production or maintenance of this highly praised website. Looking for the Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!

Powered by Dell