On 8/29/18, Dominique Devienne <ddevie...@gmail.com> wrote: > https://www.sqlite.org/limits.html doesn't say explicitly. > Unlimited? SQLITE_MAX_LENGTH ? > > PostgreSQL is limited to 63 chars. > Oracle is limited to 30 and 128 chars (latter > 12.2). > Other DBs? (just curious). --DD
There is no arbitrary limit, other than the ability of a signed 32-bit integer to measure the number of bytes. But you are limited to SQLITE_MAX_SQL_LENGTH bytes for an SQL statement, and since an identifier needs to fit inside an SQL statement, I suppose that makes the identifier length limit SQLITE_MAX_SQL_LENGTH (default: 1,000,000). -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
