Specifically, how do i make sure that the query that zope passes on to the underlying RDBMS is in utf-8 ??<br>
<br>
<br>
<br>
<br>
<br><div><span class="gmail_quote">On 5/9/05, <b class="gmail_sendername">JV Singh</b> <<a href="mailto:jvsing@gmail.com">jvsing@gmail.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Thanks for the reply.<br>
I am using Gadfly. - the one that comes with Zope... For testing whether it would work or not... <div><span class="e" id="q_103c147b2deeb9bd_1"><br><br><div><span class="gmail_quote">On 5/9/05, <b class="gmail_sendername">
Tres Seaver</b> <<a href="mailto:tseaver@palladion.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
tseaver@palladion.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">-----BEGIN PGP SIGNED MESSAGE-----<br>Hash: SHA1
<br>
<br>JV Singh wrote:<br><br>> I have been a silent member of the list mostly.. There is a slight problem<br>> that needs to be addressed rather urgently...<br>> The thing is that though unicode strings can be input and retrieved into the
<br>> database through Zope..<br>> For example, for the table EMPLOYEE<emp_id, first_name, last_name, salary><br>> the query select * from EMPLOYEE where emp_id = 3 (some number) works<br>> but<br>> select * from EMPLOYEE where first_name= 'some unicode string' doesn't
<br>> work...<br>><br>> I'd appreciate some input on this..<br><br>First, the Subject: line of your post is misleading: if you are using<br>SQL, then the problem is unrelated to ZODB.<br><br>You need to verify that whatever underlying RDBMS you are using can
<br>support the query, first, using its own query interface. Once you know<br>what the syntax for that looks like, then work out how to make your<br>DTML-based SQL method generate that.<br><br>Tres.<br>-----BEGIN PGP SIGNATURE-----
<br>Version: GnuPG v1.2.5 (GNU/Linux)<br>Comment: Using GnuPG with Thunderbird - <a href="http://enigmail.mozdev.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://enigmail.mozdev.org</a><br>
<br>iD8DBQFCf0zq+gerLs4ltQ4RAlnkAJ9UZA86AZFlxijpGpSqdDCbj6Wn1ACgmT42<br>
N0BzBRjBCWDUBGljFNvs6M0=<br>=M+JU<br>-----END PGP SIGNATURE-----<br></blockquote></div><br>
</span></div></blockquote></div><br>