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
-~----------~----~----~----~------~----~------~--~---
