|
»
Charset with hk_classes in Python and MDB
|
View:
New views
3 Messages
—
Rating Filter:
Alert me
|
 |
Charset with hk_classes in Python and MDB
by Javier Pérez-8
::
Rate this Message:
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 Hk-classes-discuss@... https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss |
|
|
Re: Charset with hk_classes in Python and MDB
by robert leleu
::
Rate this Message:
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 > Hk-classes-discuss@... > 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 Hk-classes-discuss@... https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss |
|
|
Re: Charset with hk_classes in Python and MDB
by Javier Pérez-8
::
Rate this Message:
Gracias por la respuesta Robert.
Pero necesito que el proceso sea automático. El usuario debe enviar un fichero mdb a un directorio, y mi aplicación debe importarlo a MySQL. Es por ello que estoy tratando de hacer la importación con hk_classes y Python. --- Thank you Robert for the answer. But I need to make the process automatic. User must send a MDB file to a directory, and my application must import it to MySQL. That is why I am trying to import with hk_classes and Python. On Mon, Feb 23, 2009 at 16:12, Robert Leleu <robert.jean.leleu@...> wrote: Pues que Knoda abre corectamente MDB se puede copiar los datos MDB ------------------------------------------------------------------------------ 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 Hk-classes-discuss@... https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss |
| Free embeddable forum powered by Nabble | Forum Help |
