Re: [mdb-dev] Re: problems with JET4 and nonASCI characters

[Markus N. <ne...@it...>]

On Fri, Aug 05, 2005 at 12:29:56PM -0400, Brian Bruns wrote:
> The source/target character sets can be selected using the MDB_ICONV
> environment variable, otherwise the default is UTF-8 (this all applies
> to jet4, access 97 is a different beast).  So what you're likely
> seeing is UTF-8 characters on a terminal/program which is unequiped to
> handle it.  Just set the target set like:
>=20
> export MDB_ICONV=3DISO-8859-1
>=20
> Which will work for most western european languages.  use "iconv
> --list" to see the supported values.

Phantastic - problem solved.

Would you mind to add this to the docs?

eden:doc[359.103] pwd
/hardmnt/eden0/ssi/software/mdbtools/doc
eden:doc[360.104] grep MDB_ICONV *
eden:doc[361.105]=20

=20
> Eventually it would be nice to grab this info from LC_ALL or LANG, but
> the string returned by those doesn't always map exactly to that
> required by iconv.

Ok.

Thanks, Brian.

Markus
=20
> Brian
>=20
> 2005/8/5, Markus Neteler <ne...@it...>:
> > Hi again,
> >=20
> > after the fix for the 64bit platform I can now export the data.
> > But I have the same problem as reported in
> >  http://sourceforge.net/mailarchive/forum.php?thread_id=3D7699603&for=
um_id=3D5183
> >=20
> > mdb-ver StazioniAutomatiche.mdb
> > JET4
> >=20
> > mdb-export -I StazioniAutomatiche.mdb Misure
> > ...
> > INSERT INTO Misure (Id Misura, Descrizione Misura, UM) VALUES (174,"U=
midit=E0 Massima 1440 min","%")
> > ...
> > INSERT INTO Misure (Id Misura, Descrizione Misura, UM) VALUES (6464,"=
Velocit=E0 vento Massima 15 min","m/s")
> > ...
> >=20
> > Do you see a chance to maintain the character encoding somehow or
> > map to ASCII? I am not sure if SQL is limited or permits accented
> > characters.
> >=20
> > My intention is to convert the MDB into a PostgreSQL database.
> >=20
> > Thanks
> >=20
> >  Markus
> >=20
> >=20
> > -------------------------------------------------------
> > SF.Net email is Sponsored by the Better Software Conference & EXPO
> > September 19-22, 2005 * San Francisco, CA * Development Lifecycle Pra=
ctices
> > Agile & Plan-Driven Development * Managing Projects & Teams * Testing=
 & QA
> > Security * Process Improvement & Measurement * http://www.sqe.com/bsc=
e5sf
> > _______________________________________________
> > mdbtools-dev mailing list
> > mdb...@li...
> > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
> >
>=20
>=20
> -------------------------------------------------------
> SF.Net email is Sponsored by the Better Software Conference & EXPO
> September 19-22, 2005 * San Francisco, CA * Development Lifecycle Pract=
ices
> Agile & Plan-Driven Development * Managing Projects & Teams * Testing &=
 QA
> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5=
sf
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

--=20
Markus Neteler     <neteler itc it>       http://mpa.itc.it
ITC-irst -  Centro per la Ricerca Scientifica e Tecnologica
MPBA - Predictive Models for Biol. & Environ. Data Analysis
Via Sommarive, 18        -       38050 Povo (Trento), Italy