SQLite and INT starting with zero

Tjalve · 2009-09-30 21:09:34

I have a problem with SQLite 3.0 and wodering if anyone had the same problem before.

I can't seem to save INTs starting with 0 correctly.
ex. 080168 get saved as 80168, but if i just try 0 it get saved correctly as 0.

I made a new table to test this out. Onle field with an INT value, but get the same.

Using SQLite admin and SQLite Manager.

Franz · 2009-09-30 21:16:29

I don't see the problem. What's so important about that leading zero? It saves the correct value, isn't that the important thing?

If you want to keep it, you probably have to use something like VARCHAR...

FSX · 2009-09-30 21:36:06

This is normal. The zero does not add any value to the number so why store it?

If you really want to have the 0 in front of the number then you should save it as a string (varchar), but that's kinda stupid.

Last edited by FSX (2009-09-30 21:40:36)

Tjalve · 2009-09-30 21:42:44

08 is the year so it adds something, but ill just change it to VARCHAR. Ta

FSX · 2009-10-01 06:49:00

I would use 2008. ^^

Forums