On 8 Aug 2009, at 10:16am, Gilles Ganault wrote: > Is it possible to have auto-incremented primary keys be a fixed size, > eg. 0000000001, 0000000002, etc.?
Not to start from zero that way. But you can create a record yourself which has a barcode of 1000000001 to force the number of digits, and from then SQLite will count up from that one. (Test this first, I haven't tried exactly that.) In fact this is almost certainly what you want anyway: real barcodes don't start from zero, the first few digits tend to indicate a category of some kind anyway. And the last digit is usually a checksum. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
