Mdb tool is a strong tool to convert your mdb files (microsoft access database files) to any other format. I had a problems with mdb tool with encoding.
I had a files of “bok” extension, but they are mdb files. those files are uft-8 but the content is windows-1256 and i don’t know why. Exporting the data of those files gives a corrupted data. and I couldn’t convert the output back again
Finally I gathered the scattered information about mdb-tool and I found that I have to set TWO environment variable, the first one is MDB_ICONV
The other variable related on which JET version you are using
If you have JET3 then set the second env variable MDB_JET3_CHARSET
After setting the env variables, export the data into csv file for example
mdb-export -q ‘”‘ -d ‘,’ -R ‘\n’ > file.csv
or your can get SQL insert statements:
mdb-export -I -q ‘”‘ -d ‘,’ -R ‘\n’ > file.txt
About this entry
You’re currently reading “Encoding of MDB Tool,” an entry on Faris Madi (I 've moved to http://farismadi.com/blog/)
It depends on encoding of your files. I had to set WINDOWS-1252, although my mdb files were made under windows with windows-1250 encoding (central european). Then, opening files under 1252 encoding worked. Opening them as utf with ICONV and JET_CHARSET set to utf didn’t work.