Nicky, if you get unicode working with SQLObject and MySQL, would you
maybe have time to post a short description of how you got it working?
There's a lot of people on the list who would be interested!
-ian
On Nov 17, 4:48 pm, "Nicky Ayoub" <[EMAIL PROTECTED]> wrote:
> Forget it. ( Removing egg on my face ...) I forgot to update my
> model.pyfile to use UnicodeCol...
> Off to the editor...
>
> Nicky
>
> On 11/17/06, Nicky Ayoub <[EMAIL PROTECTED]> wrote:
>
>
>
>
>
> > thanks for the note. I changed the mysql server to use utf8 and also
> > changed my database to use utf8 but the original problem still occurs...
> > The only config variable I see in TG is for kid. I set that to utf8 too...
> > I'm not sure where to look next.
>
> > [EMAIL PROTECTED] ~]$ echo status | mysql | egrep 'version|utf'
> > Using outfile: ''
> > Server version: 5.0.22
> > Protocol version: 10
> > Server characterset: utf8
> > Db characterset: utf8
> > Client characterset: utf8
> > Conn. characterset: utf8
>
> > Is it possible that I have to open the connection as utf8 or something?
>
> > Thanks again!
>
> > On 11/17/06, Diez B. Roggisch <[EMAIL PROTECTED]> wrote:
>
> > > On Friday 17 November 2006 18:29, [EMAIL PROTECTED] wrote:
> > > > Hello everyone.
> > > > I started a working TG application after upgrading to FC6. I am using
> > > > the trunk and virtual-python to set up a work environment. The problem
>
> > > > is that an incoming argument string is in unicode and the SO select
> > > now
> > > > fails :
>
> > > > l = model.Pad.byName(library)
>
> > > > To fix ( or rather mask out ) the problem I simply added:
>
> > > > library=library.encode('ascii')
>
> > > > Of course, I'll probably have to go to every method and do the same
> > > > and this naturally sucks!
> > > > I know I could change all my StringCol to UnicodeCol as most threads
> > > > suggest but I am not sure how this will affect existing MYSQL tables.
>
> > > If ascii is all you have in the DB, there won't be any unwanted effects.
> > > ascii
> > > is a subset of UTF-8.
>
> > > Diez
>
> > --
> > --
> > Nicky Ayoub
> > G-Mail Account--
> --
> Nicky Ayoub
> G-Mail Account
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
