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] -----------------------------------------------------------------------------
