No data truncation errors

No data truncation errors

am 03.02.2006 19:14:12 von Martin.Evans

Hi,

I have mysql-connector 3.51.12 and MySQL 5.0.15.

When I insert into a char column that is too small I don't seem to get a data
truncated error:

create table test (a char(10))
insert into test values ('AAAAAAAAAAAAAAAAAAAAAAAAAAAA')
returns successfully but truncates the data.

When I try this in the mysql browser it returns a data truncated message inside
a little yellow exclamation mark so it would seem MySQL knows the data is
truncated but MyODBC is not telling me. Does anyone know how to make MyODBC
return the correct data truncated error or is this a "feature" requiring a
coding change to MyODBC?

Martin
--
Martin J. Evans
Easysoft Ltd, UK
http://www.easysoft.com


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org