Peter Eisentraut wrote: > > Hiroshi Inoue writes: > > > I'm not familiar with non_ASCII locale. > > Is 'ss' always guaranteed to be LIKE 's%' for example ? > > Yes. LIKE doesn't use any collation rules, since it doesn't do any > collating. >
Hmm I see the description like the following in SQL99 though I don't understand the meaning. i) If <escape character> is not specified, then the collating sequence used for the <like predicate> is determined by Table 3, ‘‘Collating sequence usage for comparisons’’, taking <character match value> as comparand 1 (one) and <character pattern> as comparand 2. regards, Hiroshi Inoue ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
