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 the confusion.
Thanks again. Mario Figueiredo On 11/14/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
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 - any field may hold a string of any length. > However, when using an external tool (SQLite Administrator 0.8.2.6 > Beta) to read the table, it does show both fields truncated to 5 > characters. That's probably a feature of this particular tool. It's definitely not a feature of SQLite engine. Igor Tandetnik ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
