On Oct 16, 2006, at 10:43 AM, Ed Leafe wrote:
I spoke too soon. I need to work on this some more, as I've found
problems with this solution. Stay tuned.
Paul, can you verify something for me?
Run Simple...Bizobj. Search for zip=95113. The city appears as 'San
Jose'. Change it to the accented e version: San José. Are you able to
save that value? I'm not, even though the field in the table is
marked as utf8-bin encoding.
There seems to be a problem with the backend execution of the SQL
statement. It's being constructed correctly; I get:
update zipcodes set zipcodes.ccity = 'San José' where
zipcodes.iid=40390
but MySQLdb seems to be choking on that.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
