On 18 Apr 2014, at 7:29pm, Donald Griggs <dfgri...@gmail.com> wrote:
> I tried a simple test with recent [Postgres] (9.3.4) version (using default > settings, > if that matters) and verified that an insert with oversized string will > fail to insert, unless the overage characters are spaces only, in which > case it succeeds with truncation. Made even more complicated because MySQL has a 'strict' mode where this will fail, but also another mode where it will issue a warning message, but a truncated copy of the string will be stored. I had seen the truncating behaviour so many times I assumed it must be in the Standard. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users