MyODBC problem with MySQL and ACCESS
| From: | Andy | Date: | Tue, 25 Dec 2001 18:32:45 +0000 |
| Subject: | MyODBC problem with MySQL and ACCESS | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15212@lists.php.net to get a copy of this message | ||
Hi there,
I would like to transfer data from ACCESS via MyODBC towards a MySQL DB.
Reading works fine.
While writing I have a problem with data types. Not all datatypes seem to
fit. What are the proper datatypes I need to have in order to manage the
transfer?
Text does not work. I transfered it as Memo and this works. How about
integer? This does not work at all? Is there anywhere a table flying around
where I can see which datatypes I have to use?
Thanx for any help,
Cheers Andy