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

Reply via email to