Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Unicode arguments in posstr(), locate() and LIKE

 
   Database Help (Home) -> DB2 RSS
Next:  see oracle  
Author Message
rhino

External


Since: Oct 24, 2008
Posts: 1



(Msg. 1) Posted: Fri Oct 24, 2008 1:27 pm
Post subject: Unicode arguments in posstr(), locate() and LIKE
Archived from groups: comp>databases>ibm-db2 (more info?)

I'm wondering if it is possible to supply Unicode arguments to the functions
posstr() and locate() and to the LIKE predicate? If yes, could someone write
a simple example or two showing the syntax?

I'd like to be able to search a given CHAR() or VARCHAR() column for single
or concatenated Unicode strings. For example, if I want to find a tab,
followed by a accented letter like the French a grave, followed by a space,
in a CHAR() column via posstr(), locate() or LIKE, expressing the characters
in Unicode, how would I write the query?

Also, what codepage would the database need to be for this to work? And what
versions of DB2 on Windows would I need as a minimum to obtain this
functionality?

--
Rhino

 >> Stay informed about: Unicode arguments in posstr(), locate() and LIKE 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> DB2 All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]