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 <[EMAIL PROTECTED]> 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 < [EMAIL PROTECTED]> 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-----


_______________________________________________
Zope maillist  -  Zope@zope.org
http://mail.zope.org/mailman/listinfo/zope
**   No cross posts or HTML encoding!  **
(Related lists - 
 http://mail.zope.org/mailman/listinfo/zope-announce
 http://mail.zope.org/mailman/listinfo/zope-dev )

Reply via email to