Encodign issue in Python 3.3.1 (once again)

[Michael Torrie]

On 05/26/2013 11:06 PM, Νίκος Γκρ33κ wrote:
> But iu have it set up for 'utf-8' as seen in this statement.
> 
> con = pymysql.connect( db = 'metrites', host = 'localhost', user = 
> 'me', passwd = 'somepass', charset='utf-8', init_command='SET NAMES UTF8' ) 

That might not help... see below.

> 
> Yoiu mean i shoudl chnag eit to greek isoo= (iso-8859-7)
> but then i store english names and greek names as well, so it has to be a utf-8.

Right.  UTF-8 is the encoding you want.

I think your problem is that when the MySQL database was created, it was
not created using the UTF-8 mode, but rather latin-1 (despite your
init_command which has nothing to do with database creation).  You'll
want to recreate the database and make double sure you've selected the
right character set and collation:

http://dev.mysql.com/doc/refman/5.0/en/charset-applications.html

At least that should be your first step in debugging this problem.

If the database is indeed utf-8, then you can move on to debugging why
the python code is choosing latin-1 to encode your query string.

That's my two-cents for today.