Re: [sqlite] [EXTERNAL] char(0) with SQLite

2019-09-02 Thread Dominique Devienne
On Mon, Sep 2, 2019 at 12:12 PM Hick Gunter wrote: > Dimensions are ignored by SQLite. A field defined CHAR(0) can hold any > length (up to the internal limit) of string. SQlite will only store the > actual length of the string plus its contents, no space is wasted. And Gunter wrote "string" a

Re: [sqlite] [EXTERNAL] char(0) with SQLite

2019-09-02 Thread Olivier Mascia
> Le 2 sept. 2019 à 12:12, Hick Gunter a écrit : > >> Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] Im >> Auftrag von Grincheux >> Into my db I store passwords having differents lengths (from 1 to 50). >> I don't want to give the max size that woud be using space I don'

Re: [sqlite] [EXTERNAL] char(0) with SQLite

2019-09-02 Thread Hick Gunter
Dimensions are ignored by SQLite. A field defined CHAR(0) can hold any length (up to the internal limit) of string. SQlite will only store the actual length of the string plus its contents, no space is wasted. -Ursprüngliche Nachricht- Von: sqlite-users [mailto:sqlite-users-boun...@mail