Packageflash.data
Classpublic class SQLCollationType
InheritanceSQLCollationType Inheritance Object

Language version: ActionScript 3.0
Runtime version: AIR 1.0

This class contains the constants that represent the possible values for the 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

flash.data.SQLColumnSchema.defaultCollationType


Public Properties
 PropertyDefined by
 Inheritedconstructor : Object
A reference to the class object or constructor function for a given object instance.
Object
 Inheritedprototype : Object
[static] A reference to the prototype object of a class or function object.
Object
Public Methods
 MethodDefined by
 Inherited
Indicates whether an object has a specified property defined.
Object
 Inherited
Indicates whether an instance of the Object class is in the prototype chain of the object specified as the parameter.
Object
 Inherited
Indicates whether the specified property exists and is enumerable.
Object
 Inherited
Sets the availability of a dynamic property for loop operations.
Object
 Inherited
Returns the string representation of this object, formatted according to locale-specific conventions.
Object
 Inherited
Returns the string representation of the specified object.
Object
 Inherited
Returns the primitive value of the specified object.
Object
Public Constants
 ConstantDefined 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
Constant detail
BINARYconstant
public static const BINARY:String = "binary"

Language version: ActionScript 3.0
Runtime version: 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_CASEconstant 
public static const NO_CASE:String = "noCase"

Language version: ActionScript 3.0
Runtime version: 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