Re: [sqlite] Re: (New SQLite user) - ANSI Datatypes

2006-11-14 Thread Mario Figueiredo
Thanks both. Probably the SQLite Manager is getting that information from the table schema. But most important is the newly acquired knowledge that SQLite does ignore the lenght restriction. That information is actually already in the documentation. But the third party software was generating

[sqlite] Re: (New SQLite user) - ANSI Datatypes

2006-11-14 Thread Igor Tandetnik
Mario Figueiredo <[EMAIL PROTECTED]> wrote: Are ANSI datatypes recognized? I'm particularly interested in CHAR(X) and VARCHAR(X). And they seem to work in a way I can't understand. A column declared with any type that has "char" in it has string affinity. The length restriction is ignored -