python through fcgi

major · 2006-07-26 18:02:48

Ok, since i dont like php that much and wanted to write a webbpage i thought python whould be a good choice. I run lighttpd with python through fcgi. It works fine except when i want to put a string containing "åäö" (swedeish chars) in mysql.
i get this errormsg:

http://www.ds.hj.se/~major/fel.html

The thing is that when i use mysql-cmd i can use åäö like theres no tomorrow, and python/lighttpd can display then properly on the page.

I know it has to do with charsets and such but i dont know where to change it. Has anyone else had this problem? How to solve?

codemac · 2006-07-26 19:14:00

query = "insert into cp values('bajs', 'xe5xe4xf6')", query.encode = <built>, charset = 'latin1'

exceptions.UnicodeDecodeError: 'ascii' codec can't decode byte 0xe5 in position 31: ordinal not in range(128)

change charset='latin1' to charset='utf8'. At least I think it is utf8 it may be some other string, but that's what you need to change.

major · 2006-07-26 20:32:41

ok. tried modifying the lib-source. No dice.

The script works fine on another server i might add. But as far as i can tell the only difference is the mysqld-version. I have 5.0.22 and the other server use 4.0.24.

I think that the problem is with mysql, but i cant seem to find any info on how to get it to work

cactus · 2006-07-26 20:55:14

what is the char encoding set to on the actual mysql table?

major · 2006-07-26 21:06:06

looks like latin1 to me...

cactus · 2006-07-26 22:05:03

ALTER TABLE tbl_name
    [[DEFAULT] CHARACTER SET charset_name] [COLLATE collation_name]

you might try altering the character set on that table..
Not sure what character set you would want to use though..maybe latin1_swedish_ci. That is one of the common ones I see..seems fairly compatible.

ALTER TABLE cp CHARACTER SET latin1_swedish_ci COLLATE latin1_swedish_ci;

http://dev.mysql.com/doc/refman/5.0/en/ … yntax.html

Not sure if you need to change the column char sets themselves...
but who knows.. we could be barkup up the wrong tree..but I think we are on the right track.

user · 2006-07-26 22:23:58

> since i dont like php that much and wanted to write a webbpage i thought python whould be a good choice.

try this,
http://www.conflux.ee/

postlogic · 2006-07-27 09:35:50

user wrote:

> since i dont like php that much and wanted to write a webbpage i thought python whould be a good choice.
try this,
http://www.conflux.ee/

How does that aid him in actually writing a site?

major · 2006-07-27 10:02:31

cactus:
No dice.

and, the conflux-thingie... not even sure wtf it is.. but it wont help me in any way. that im sure about.

Kopsis · 2006-07-27 14:11:30

The problem isn't the Latin1 encoding (Latin1 should work fine for Swedish) it's that your MySQLdb Python extension is trying to encode your SQL not as Latin1 but as ASCII (which means no chars beyond 0x7F).

I haven't tried to deal with this myself, but there is a bunch of possibly related discussion here

major · 2006-07-27 16:34:32

Yeah, that its trying to use "ASCII" ive figured out.

>>> import MySQLdb
>>> db=MySQLdb.connect(host='localhost', user='major', passwd='**********', db='bajs', use_unicode=True)
>>> db.character_set_name()
'latin1'
>>>

So.... it should use latin1, right?

Arch Linux

#1 2006-07-26 18:02:48

python through fcgi

#2 2006-07-26 19:14:00

Re: python through fcgi

#3 2006-07-26 20:32:41

Re: python through fcgi

#4 2006-07-26 20:55:14

Re: python through fcgi

#5 2006-07-26 21:06:06

Re: python through fcgi

#6 2006-07-26 22:05:03

Re: python through fcgi

#7 2006-07-26 22:23:58

Re: python through fcgi

#8 2006-07-27 09:35:50

Re: python through fcgi

#9 2006-07-27 10:02:31

Re: python through fcgi

#10 2006-07-27 14:11:30

Re: python through fcgi

#11 2006-07-27 16:34:32

Re: python through fcgi

Board footer