[Zope] Re: problem with ZODB

[Tres Seaver]

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