Package | flash.data |
Class | public class SQLCollationType |
Inheritance | SQLCollationType Object |
Language Version: | ActionScript 3.0 |
Runtime Versions: | AIR 1.0 |
defaultCollationType
parameter of the SQLColumnSchema constructor, as well as the
SQLColumnSchema.defaultCollationType
property.
These values represent different collation sequences that can be specified for a column in a database table. A collation sequence is a way of sorting and comparing data, for example whether the database differentiates between uppercase and lowercase characters.
For more information about defining and using collation sequences, see the "COLLATE" section in the appendix "SQL support in local databases."
See also
Constant | Defined By | ||
---|---|---|---|
BINARY : String = "binary" [static]
Indicates that the column is defined to use the BINARY collation sequence. | SQLCollationType | ||
NO_CASE : String = "noCase" [static]
Indicates that the column is defined to use the NOCASE collation sequence. | SQLCollationType |
BINARY | Constant |
public static const BINARY:String = "binary"
Language Version: | ActionScript 3.0 |
Runtime Versions: | AIR 1.0 |
Indicates that the column is defined to use the BINARY
collation sequence.
A SQLCollationType.BINARY
collation compares two
values using their byte values, regardless of the text encoding of the characters.
When binary collation is used with values of the TEXT
storage class, the database
differentiates between uppercase and lowercase characters when sorting and comparing the column's
values.
See also
NO_CASE | Constant |
public static const NO_CASE:String = "noCase"
Language Version: | ActionScript 3.0 |
Runtime Versions: | AIR 1.0 |
Indicates that the column is defined to use the NOCASE
collation sequence.
A SQLCollationType.NO_CASE
collation ignores uppercase and lowercase differences
when sorting and comparing two values.
See also
Fri Mar 19 2010, 02:45 AM -07:00