Pues que Knoda abre corectamente MDB se puede copiar los datos MDB
vistas a través de Knoda (seleccionandolos) y pegarlos en una tabla
(Excel, ó Ooffice) preparada en UTF-8
De allá se convierta en CSV y es posible importarla el CSV al Mysql. Yo,
hace tiempo, importé asi los datos de mí antiguo sístemo (Windev, Win98)
Javier Pérez skribis (esperanto estas la unua internacia lingvo):
> Hello.
>
> I need to import a MDB database to my MySQL database, but I have some
> problems with charset in MDB.
>
> ñ, tildes, and any other character out of ascii charset is deleted
> when hk_classes gives me data.
>
> For example: "/El vino mejor*ó* con los a*ñ*os/" is "translated" to
> "/El vino mejor con los aos/".
>
> Is there eny option to change the character set to database object. I
> tried to use db.set_databasecharset('any') but no changes.
>
> Curiously, Knoda open the MDB file with right charset...
>
> My code:
> driver = hk_classes.hk_drivermanager()
> con = driver.new_connection('mdb')
> db = con.new_database( 'myfile.mdb')
> db.set_databasecharset('some-charset')
>
> table = db.new_table( 'mytable')
> table.enable()
>
> table.first()
> print table.show_currentrow()
> # and here it shows bad-encode data
>
> Any help will be welcomed. Thank you.
>
> Sorry for my bad english.
>
>
> ------------------------------------------------------------------------
>
> ------------------------------------------------------------------------------
> Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
> -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
> -Strategies to boost innovation and cut costs with open source participation
> -Receive a $600 discount off the registration fee with the source code: SFAD
> http://p.sf.net/sfu/XcvMzF8H
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Hk-classes-discuss mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
------------------------------------------------------------------------------
Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA
-OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise
-Strategies to boost innovation and cut costs with open source participation
-Receive a $600 discount off the registration fee with the source code: SFAD
http://p.sf.net/sfu/XcvMzF8H
_______________________________________________
Hk-classes-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
