Here's the result:
In[21]: Title(booktitle=u'étape', kindID=1)
Out[21]: Title is: title names are: [u'publisher', u'isbn', 'kind_id',
'booktitle', u'release_date', u'edition', u'tag', u'type'] values are: [' ', '
', 1, '\xc3\xa9tape', None, None, None, None]
So, yes, there are unicode strings in the names. Oddly enough, the only ones
that are unicode are the ones that are fromTable (booktitle is the only
declared UnicodeCol & kindID is a foreign key)
Now, the weird part is that when I add an ascii compatible string, despite the
fact that some of the names are still unicode, it all works and I get a
sqlobject entered in the database:
In[22]: Title(booktitle=u'tape', kindID=1)
Out[22]: title [u'publisher', u'isbn', 'kind_id', 'booktitle',
u'release_date', u'edition', u'tag', u'type'] [' ', ' ', 1, 'tape', None, None,
None, None]
<Title 11275L booktitle=u'tape' kindID=1L isbn=u' ' publisher=u' '
releaseDate=None tag=None edition=None type=None>
Thanks, Oleg, unicode errors still always manage to confuse the hell out of
me...
--Marko
On Mon, 2012-02-28 09:11, Oleg Broytman wrote:
> 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:@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@...
> 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
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
