Re: web app breakage with utf-8

2006-07-07 Thread Justin Ezequiel
replacing connection.character_set_name instance method seems to work but is this the correct/preferred way? >>> import MySQLdb >>> MySQLdb.get_client_info() '4.1.8' >>> import sys >>> sys.version '2.3.4 (#53, May 25 2004, 21:17:02) [MSC v.1200 32 bit (Intel)]' >>> sys.platform 'win32' >>> cred =

Re: web app breakage with utf-8

2006-07-06 Thread elmo
On Thu, 06 Jul 2006 19:41:32 +, elmo wrote: > I guess it could be a new MySQLdb issue causing breakage. > Replying to self, this is *very* close to the problem: http://sourceforge.net/tracker/index.php?func=detail&aid=1438913&group_id=22307&atid=374932 -- http://mail.python.org/mailman/lis

Re: web app breakage with utf-8

2006-07-06 Thread elmo
On Thu, 06 Jul 2006 19:16:53 +0200, Stefan Behnel wrote: >> >> Is there a correct way to handle text input from a when the page is >> utf-8 and that input is going to be used in SQL statements? I've tried >> things like (with no success): >> sql = u"select * from blah where col='%s'" % input >

Re: web app breakage with utf-8

2006-07-06 Thread Stefan Behnel
elmo wrote: > Hello, after two days of failed efforts and googling, I thought I had > better seek advice or observations from the experts. I would be grateful > for any input. > > We have various small internal web applications that use utf-8 pages for > storing, searching and retrieving user inpu

web app breakage with utf-8

2006-07-06 Thread elmo
Hello, after two days of failed efforts and googling, I thought I had better seek advice or observations from the experts. I would be grateful for any input. We have various small internal web applications that use utf-8 pages for storing, searching and retrieving user input. They have worked fine