ODBC and table large names

[Anon]

Hi there

i must to migrate an access database(windows) to mysql(linux)
i try with UnixOdbc but the bridge don't work 🙁
so i install php+apache under windows and write a script, the script's output is the sql for mysql (it works 🙂!!!)

the trouble was with some field's name php trunc the field name

anibody has any idea?

thx!

ANDRES BAZURTO

[diz_z_eye]

download this windows based app...(are you running mySQL on a win32 platform or UNIX/Linux ?) You may need to install the myODBC drivers??

Anyway this app is AWESOME!!! it will recreate your complete DB on your mySQL server...should handle all of the name/datatype conversions without losing any data. ( took lesss than a minute for our D😎

GOOD LUCK!

schaazam
Shawn beeson

[Anon]

I had the same problem. If it does get truncated, you might want to use the blob field in mySql. I think that's a dynamically sizing field.