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