Re: UTF8 : LIKE does not support character expansion ?
This is normal. The "norm" (the SQL Standard document) says:
If the i-th substring of [pattern] is a
[character other than _ or %], then the i-th
substring of [expression] contains exactly
one (1) character that is equal to [it]
according to the collation
Thus a LIKE search is character by character.
Subject
Views
Written By
Posted
11649
July 22, 2006 04:33AM
4150
July 22, 2006 06:05AM
Re: UTF8 : LIKE does not support character expansion ?
3911
July 25, 2006 08:18AM
3868
July 26, 2006 01:43AM
3435
July 26, 2006 01:08PM
3359
July 26, 2006 11:29PM
3133
July 26, 2006 11:40PM
3094
July 26, 2006 11:51PM
3086
July 27, 2006 12:49AM
5114
July 27, 2006 01:21AM
2648
July 28, 2006 03:26AM
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.