On Mon, Sep 2, 2019 at 12:12 PM Hick Gunter <h...@scigames.at> 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" above, but SQLite will also hold an integer, or real, or blob value in that row/col (i.e. cell) just as well :) --DD PS: Note that if you use the text type for your password, note that the text is expected to be UTF-8. If you users use accented characters in an 8-bit encoding, and you do not properly convert that into UTF-8, this could perhaps create issues (although if you take that UTF-8, and manipulate it assuming the same 8-bit encoding, SQLite should give you back the same bytes, it doesn't do UTF-8 validation AFAIR). Otherwise use a blob and conventions/assumptions in your app. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
