flash.data.SQLCollationType - Adobe® Flex® 4 Language Reference (Flex 4)

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."

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
		prototype : Object [static] A reference to the prototype object of a class or function object.	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.

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.