[prev in list] [next in list] [prev in thread] [next in thread] 

List:       jboss-user
Subject:    [JBoss-user] ILIKE and TRANSLATE in Jboss-ql
From:       pbarreiros () simauria ! net
Date:       2003-05-29 10:36:42
[Download RAW message or body]



hi,

i use jboss 3.2.1 and <jboss-ql> tag in my jbosscmp-jdbc.xml

i try to compare data (some chars in lower/uppercase) with another 
data in the DB

example: i compare 'pétEr smiTh' with 'Peter Smïth' and i hope to give 
true.

i always use ILIKE clausule and TRANSLATE function to compare data
without considering uppercases and translate some chars

ILIKE and TRANLATE are in SQL92 but i think they aren´t in jboss-ql

anyone knows what can i do?, how can i compare data whose some chars are 
lower or uppercase. how i can translate some chars in jboss-ql SELEC?

thanks in advance.


-- 

     Pedro Barreiros     |     Simauria Networks
 ----------------------------------------------------
 pbarreiros@simauria.net |   simauria@simauria.net
     Tlf: 620 199 405    |  http://www.simauria.net
 ----------------------------------------------------
         C/ Cádiz, 90 pta 6. 46006 Valencia.
    Tlf: +34 963.44.48.48 - Fax: +34 963.44.48.49
 ----------------------------------------------------



-------------------------------------------------------
This SF.net email is sponsored by: eBay
Get office equipment for less on eBay!
http://adfarm.mediaplex.com/ad/ck/711-11697-6916-5
_______________________________________________
JBoss-user mailing list
JBoss-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jboss-user
[prev in list] [next in list] [prev in thread] [next in thread]