Dennis Cote <[EMAIL PROTECTED]> 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 <name>)
> CAST( <src> AS text COLLATE <name>)
> column1 COLLATE <name>
> 'a string' COLLATE <name>
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 <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
