Which databases cannot accept, and do something reasonable, with a
VARCHAR field declaration of 1024 characters?
The question is carefully worded because I'm *not* asking for databases
that support VARCHAR(1024) as a valid VARCHAR length, allthough it
might seems like it :)
I'm asking which databases would either give an error or truncate the
data when presented with these two statements:
CREATE TABLE foo (
bar VARCHAR(1024)
);
INSERT INTO foo (bar) VALUES ('...1024 characters...');
For example, MySQL only supports VARCHAR fields up to 255 characters,
but will pass the test above because it'll silently convert VARCHAR(1024)
into a TEXT type column (ie a LONG).
So, back to the original question: Which databases cannot accept,
and do something reasonable, with a VARCHAR field declaration of
1024 characters?
Tim.
p.s. You can keep the answers terse.
