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