I tried to export a table from ACCESS to odbc database. This table had an auto-increment field (the first) and then a bunch of varchar fields. The length parameters for the varchar fields were not forwarded in the CREATE statement. Here's the failed line in mysql.log: 010612 13:56:46 73 Query CREATE TABLE `Customers`(`CustomerID` integer,`CompanyName` varchar,`ContactFirstName` varchar,`ContactLastName` varchar,`CompanyOrDepartment` varchar,`BillingAddress` varchar,`City` varchar,`StateOrProvince` varchar,`PostalCode` varchar,`Country` varchar,`ContactTitle` varchar,`PhoneNumber` varchar,`Extension` varchar,`FaxNumber` varchar,`EmailAddress` varchar,`Notes` varchar) I am pretty sure that this worked a while ago (different version of myodbc), where the table was created but I still had to put the index information (and auto increment) by hand. Am I making this up, or is this broken now? --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
