flash.data

# SQLCollationType - AS3

Package | flash.data
Class | public class SQLCollationType
Inheritance | SQLCollationType 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
Hide Inherited Public Properties
Show Inherited Public Properties

| Property | Defined By
--- | --- | ---
|  | constructor : Object A reference to the class object or constructor function for a given object instance. | Object

Public Methods
Hide Inherited Public Methods
Show Inherited Public Methods

| Method | Defined By
--- | --- | ---
|  | hasOwnProperty(name:String):Boolean Indicates whether an object has a specified property defined. | Object
|  | 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
|  | propertyIsEnumerable(name:String):Boolean Indicates whether the specified property exists and is enumerable. | Object
|  | setPropertyIsEnumerable(name:String, isEnum:Boolean = true):void Sets the availability of a dynamic property for loop operations. | Object
|  | toLocaleString():String Returns the string representation of this object, formatted according to locale-specific conventions. | Object
|  | toString():String Returns the string representation of the specified object. | Object
|  | valueOf():Object Returns the primitive value of the specified object. | Object

Public Constants

| 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

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

© 2015 Adobe Systems Incorporated. All rights reserved.
Mon Apr 10 2017, 12:28 PM -07:00