No data truncation errors

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 [at] m.gmane.org
Martin.Evans [ Fr, 03 Februar 2006 19:14 ] [ ID #1171487 ]
Datenbanken » gmane.comp.db.mysql.odbc » No data truncation errors

Vorheriges Thema: #deleted in Access
Nächstes Thema: Possilbe bug with SQLExecute/SQLRowCount and updating rows