headers
Markos Kapes | 28 Feb 2012 02:20
Picon

Unicode probs...

I"m getting a UnicodeDecodeError and I"m unsure how to fix it...
/Library/Python/2.7/site-packages/sqlobject/dbconnection.pyc in _insertSQL(self, table, names, values) 460 return ("INSERT INTO %s (%s) VALUES (%s)" % 461 (table, ', '.join(names), --> 462 ', '.join([self.sqlrepr(v) for v in values]))) 463 464 def transaction(self): UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 14: ordinal not in range(128)
I'm using sqlobject 1.2.1, mysqldb 1.2.3 and the tables in the database are formatted for unicode. The objects' columns in sql are UnicodeCol. The connection string for the database is 
 u'mysql://dbuser: <at> localhost/databasename?debug=1&logger=MyLogger&loglevel=debug&use_unicode=1&charset=utf8'
Not sure what else to try....

Thanks for any help.....
--marko
 
------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss <at> lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
Permalink | Reply |
headers
Oleg Broytman | 28 Feb 2012 10:11
X-Face
Favicon
Gravatar

Re: Unicode probs...

On Mon, Feb 27, 2012 at 08:20:57PM -0500, Markos Kapes wrote:
> I"m getting a UnicodeDecodeError and I"m unsure how to fix it...
> 	/Library/Python/2.7/site-packages/sqlobject/dbconnection.pyc in _insertSQL(self, table,
names, values)
>     	460         return ("INSERT INTO %s (%s) VALUES (%s)" %
>     	461                 (table, ', '.join(names),
>     --> 462                  ', '.join([self.sqlrepr(v) for v in values])))
>     	463 
>     	464     def transaction(self):
> 
> 	UnicodeDecodeError: 'ascii' codec can't decode byte 0xc3 in position 14: ordinal not in range(128)
> I'm using sqlobject 1.2.1, mysqldb 1.2.3 and the tables in the database are formatted for unicode. The
objects' columns in sql are UnicodeCol. The connection string for the database is 
> 	u'mysql://dbuser: <at> localhost/databasename?debug=1&logger=MyLogger&loglevel=debug&use_unicode=1&charset=utf8'
> Not sure what else to try....

   Can you test if there are unicode names in the ``names`` list?

Oleg.
--

-- 
     Oleg Broytman            http://phdru.name/            phd <at> phdru.name
           Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
Permalink | Reply |

Gmane