I am just starting to look at MySQL and investigating its potential use for me. I am generally working in two languages at the moment which can both access SQL servers. I am trying one (at the moment) that interfaces via the ODBC driver. I have a test setup installed by using the programs on my Windows 2000 PC and MySQL running on my laptop (Windows XP).

I have constructs that can create a table definition and copy data from native tables to the SQL server. This is used successfully with other SQL Servers such as MS & Oracle. I am getting funny results with numbers using MySQL though. e.g. I have a table with a unique column called sequence. This is an integer field with a format "999". The app auto creates a table with a column smallint(6).

The problem is with the data. My first created column has the value 0 (original value 1), all other values are 8448 (original being 2,3,4,...). I am now trying to work out if the problem is with the ODBC driver or elsewhere.

Has anyone had similar problems with ODBC?

Regards

Kerry