Hello Everyone.. 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.. --JV.
-----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-----
--On Montag, 9. Mai 2005 17:04 Uhr +0530 JV Singh <jvsing@gmail.com> wrote:
Hello Everyone.. 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...
What means 'some unicode string'? An UTF8 encoded string? A Python unicode string? And *does* it not work? Any error message? Please give a *detailed* description of the error you got... -aj
participants (3)
-
Andreas Jung -
JV Singh -
Tres Seaver