select x, y, z
from t1
where collate binary x = y ;
collating_expr ::= [collate <name>] expr ;
The collating expression would apply to both x and y.
[EMAIL PROTECTED] wrote: Dennis Cote wrote:
>
> In the standard character strings have a couple of attributes, a
> character set and a collation. SQLite does not support multiple
> character sets, so we can ignore that attribute. This leaves each string
> with a collation attribute. This attribute can be specified explicitly
> in data type clause of a column definition, or in the data type clause
> of a cast expression, or directly with an explicit COLLATE clause after
> a string expression, even on a string literal.
>
> create table t (column1 text COLLATE )
> CAST( AS text COLLATE )
> column1 COLLATE
> 'a string' COLLATE
What are the precedences. If I say:
x COLLATE seq1 || y COLLATE seq2
Does that mean:
(x COLLATE seq1) || (y COLLATE seq2)
Or does it mean
((x COLLATE seq1) || y) COLLATE seq2
--
D. Richard Hipp
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
