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...@mailinglists.sqlite.org] Im Auftrag von Grincheux Gesendet: Sonntag, 01. September 2019 08:14 An: sqlite-users@mailinglists.sqlite.org Betreff: [EXTERNAL] [sqlite] char(0) with SQLite 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't need. I found that sqlite permits char(0) but what is the incidence for my db. -- Sent from: http://sqlite.1065341.n5.nabble.com/ _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___________________________________________ Gunter Hick | Software Engineer | Scientific Games International GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43 1 80100 - 0 May be privileged. May be confidential. Please delete if not the addressee. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
