howdy.
I'm using SqlAlchemy on MySql in TG and have a very specific question
about the role of the dburi and how it has affected a specific column
used for pickling.
I have a table that has 2 columns reserved for pickling results
(dumps). This will not work with unicode, so I declared the columns
like this in the model.py:
when = column(String()) #
pickled rrule instance
This works fine, as long as the dburi in my tg config file is this:
sqlalchemy.dburi="mysql://tguser:[EMAIL PROTECTED]:3306/vor"
AND NOT THIS:
sqlalchemy.dburi="mysql://tguser:[EMAIL PROTECTED]:3306/vor?
use_unicode=1"
So, I have a bit of a dilemma possibly but my understanding of the
interplay between the various components is hazy at best.
What exactly are the ramifications of the 'use_unicode=1' parameter
in the dburi?
Why can't the String() type in SqlAlchemy play well when
use_unicode=1?
Or should 'use_unicode=1' be avoided since it forces all columns to be
treated as unicode?
Sorry, I'm just not well educated on unicode as it pertains to mysql,
sqlalchemy and turbogears.
can someone shed some light on this topic?
TIA,
Jesse
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
