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