[wxPython-users] Charset problem in a WxApp

[Werner F. Bruhin]

Hi Javier,

Javier Castrillo wrote:
> Hi everybody. I'm deploying my first "big" aplication in wxPython and
> I'm very glad with this great languaje. (yes, my English is terrible,
> sorry, I'm workig on it too  :-) )
> My aplication is an school administrator and basically speaks with a
> MySQL database through a Frame with menus. It grows day by day, when
> its become serius, I'll publish it by GPL license. (The actual full
> code is attached too).
>
> Like an Spanish talker, I need some characters like ñ, á, é, í, ó, ú,
> etc, that are bringing me some troubles. I need some help to fix some
> errors. I'll try to explain these:
Just a guess, on your database connect I don't see that you specify what 
character set you are working with.

Is the data stored in your SQL DB in utf-8 or in some other encoding?  I 
am not using MySQL, but I would think that you can tell it what 
character set you want to work with, on mine (orm/kinterbasdb with 
Firebird) the connect string looks like:

                    self.ds = datasource(adapter="firebird", 
database=self.dbfilename,
                                user="userid", password="pw",
                                charset="ISO8859_1")

Hope this helps
Werner