ActionScript® 3.0 Reference for the Adobe® Flash® Platform
Home  |  Show Packages and Classes List |  Packages  |  Classes  |  What's New  |  Index  |  Appendixes
flash.data 

SQLCollationType  - AS3

Packageflash.data
Classpublic class SQLCollationType
InheritanceSQLCollationType Inheritance Object

Language Version: ActionScript 3.0
Runtime Versions: 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."

Related API Elements

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
Public Methods
 MethodDefined By
 Inherited
hasOwnProperty(name:String):Boolean
Indicates whether an object has a specified property defined.
Object
 Inherited
isPrototypeOf(theClass:Object):Boolean
Indicates whether an instance of the Object class is in the prototype chain of the object specified as the parameter.
Object
 Inherited
propertyIsEnumerable(name:String):Boolean
Indicates whether the specified property exists and is enumerable.
Object
 Inherited
setPropertyIsEnumerable(name:String, isEnum:Boolean = true):void
Sets the availability of a dynamic property for loop operations.
Object
 Inherited
toLocaleString():String
Returns the string representation of this object, formatted according to locale-specific conventions.
Object
 Inherited
toString():String
Returns the string representation of the specified object.
Object
 Inherited
valueOf():Object
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
    

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.

Related API Elements

flash.data.SQLColumnSchema.defaultCollationType
    

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.

Related API Elements

flash.data.SQLColumnSchema.defaultCollationType



© 2014 Adobe Systems Incorporated. All rights reserved.
Thu Dec 4 2014, 05:50 PM -08:00
 

 

Legal Notices | Online Privacy Policy