Re: UTF8 : LIKE does not support character expansion ?
Posted by: Bogdan Enache
Date: July 26, 2006 11:51PM

Version for more than 1 row, if anyone's interested...:

SELECT * FROM t56 WHERE (s1 LIKE '%aaa%' COLLATE utf8_general_ci AND s2 LIKE '%nta%' COLLATE utf8_general_ci)

'aăâ', 'Constanţă'

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.