then you're telling MySQL to insert a number, and number don't have
leading zeros. Behind the scenes, MySQL is then coercing the number
to a string to put in the field, but it starts as a number. If you
wrap it in quotes, then MySQL will never interpret it as a number, so
it'll retain it's leading zeros.
cheers,
barneyb
On Mon, 9 Aug 2004 03:03:19 -0400, dave <[EMAIL PROTECTED]> wrote:
> having some troubles inserting, lol
> problem is that if i copy and paste(which i have to do) the # maybe like this 06618300 but when its inserted it strips the zero off the front to this 6618300.
> its mysql the field is a varchar cause it could also have letters.
> its really not a big deal except that i have a check in place to stop dups which that reall messes it up
> tia
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
