Data truncation in modified character columns

[Peter Melvyn]

Hi all.

please, is anybody out there who could shed light on data truncation? It seems to me a little bit mystic...
If I've tried to alter CHAR and VARCHAR columns (UTF-8, not indexed) and got different results on different types of truncation:

CHAR(x) -> CHAR(y), y < x: Error 1265: Data Truncated for ..., no schema change
CHAR(x) -> VARCHAR(y), y < x: Error 1406: Data too long for ..., no schema change
VARCHAR(x) -> CHAR(y), y < x: Error 1406: Data too long for ..., no schema change
VARCHAR(x) -> VARCHAR(y):
2 < y < x: No Erros, schema changed, no data truncation
2 >= y < x: Error 1265: Data Truncated for ..., no schema change

I have MySQL Community server 5.0.37 on Windows 2KSP4

Thanks, Peter



Edited 2 time(s). Last edit at 05/03/2008 04:47AM by Peter Melvyn.