Login | Register
My pages Projects Community openCollabNet

Discussions > dev > Re: profile schema error > Reply to message

Project highlights: Stable Version: 1.6.1, Development Version: 1.7.6

Reply to message

* = Required fields
* Subject
* Body
Send reply to
Author (directly in email)
Please type the letters in the image above.

Original message

Author theslack
Full name Jack Neely
Date 2006-09-11 12:11:30 PDT
Message Read up on SQLite. It does some unique things with typing. Each cell
has a type associated with it rather than the entire column.

Its loose-typing does have some cons as well.


On 9/11/06, Jared Greenwald <greenwaldjared@g​mail.com> wrote:
> in the pysqlite/schem.py file, the profile.uuid column is defined as
> varchar(32) not null unique. I carried this over to oracle and ran
> into a problem. The problem is that the uuid is 37 char long, not 32.
> So, I went and checked the sqlite db I had from before and sure
> enough it stored 37 chars. How screwed up is that? I changed mine to
> 64, but that's just wrong.
> -Jared
> --------------------​--------------------​--------------------​---------
> To unsubscribe, e-mail: dev-unsubscribe@curr​ent.tigris.org
> For additional commands, e-mail: dev-help at current dot tigris dot org