[Zope] Encoding of the query that zope passed to the RDBMS

[JV Singh]

Specifically, how do i make sure that the query that zope passes on to the 
underlying RDBMS is in utf-8 ??





On 5/9/05, JV Singh <jvsing at gmail.com> wrote:
> 
> Thanks for the reply.
> I am using Gadfly. - the one that comes with Zope... For testing whether 
> it would work or not... 
> 
> On 5/9/05, Tres Seaver < tseaver at palladion.com> wrote:
> > 
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> > 
> > JV Singh wrote:
> > 
> > > I have been a silent member of the list mostly.. There is a slight 
> > problem
> > > that needs to be addressed rather urgently...
> > > The thing is that though unicode strings can be input and retrieved 
> > into the 
> > > database through Zope..
> > > For example, for the table EMPLOYEE<emp_id, first_name, last_name, 
> > salary>
> > > the query select * from EMPLOYEE where emp_id = 3 (some number) works
> > > but
> > > select * from EMPLOYEE where first_name= 'some unicode string' doesn't 
> > 
> > > work...
> > >
> > > I'd appreciate some input on this..
> > 
> > First, the Subject: line of your post is misleading: if you are using
> > SQL, then the problem is unrelated to ZODB.
> > 
> > You need to verify that whatever underlying RDBMS you are using can 
> > support the query, first, using its own query interface. Once you know
> > what the syntax for that looks like, then work out how to make your
> > DTML-based SQL method generate that.
> > 
> > Tres.
> > -----BEGIN PGP SIGNATURE----- 
> > Version: GnuPG v1.2.5 (GNU/Linux)
> > Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
> > 
> > iD8DBQFCf0zq+gerLs4ltQ4RAlnkAJ9UZA86AZFlxijpGpSqdDCbj6Wn1ACgmT42
> > N0BzBRjBCWDUBGljFNvs6M0=
> > =M+JU
> > -----END PGP SIGNATURE-----
> > 
> 
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope/attachments/20050509/18952053/attachment.htm