On Wed, Aug 29, 2018 at 12:09 PM Richard Hipp <d...@sqlite.org> wrote:
> 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). > Minus the minimum required CREATE TABLE ... (a), so 17 chars :) Thanks Richard. Wanted to confirm I wasn't missing anything here. --DD _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users