sp_GetCollationTable

Advantage SQL Engine

Retrieve all information for the named dynamic collation.

Syntax

sp_GetCollationTable(

Name,CiCharacter,100,

ShortName,CiCharacter,8,

CodePage,Integer )

Parameters

Name (I)	The unique long name of the collation (e.g., GENERAL_VFP_CI_AS_1252). If this name is given, the ShortName and CodePage parameters are given. If this name is NULL or empty, the ShortName and CodePage must be given.
ShortName (I)	Instead of sending the long name, the short Visual FoxPro name (GENERAL) can be passed in this parameter. If this is given, then the desired codepage must also be supplied.
CodePage (I)	If ShortName is given instead of the long unique name, then the desired codepage (e.g., 1252) must be supplied to make the search unique.

Output

The sp_GetCollationTable procedure will return a result set with a single row.

Field Name	Field Type	Field Size	Description
CollationID	Integer	4	This is the ID of the collation on the server. It is for internal use.
Name	CiCharacter	100	The long unique collation name.
ShortName	CiCharacter	8	The short collation name. This is the name that is used directly in Visual FoxPro.
Version	Integer	4	The version number of the collation table.
CodePage	Integer	4	The codepage for which the collation was created.
CE	Blob	9	This contains the collation information.
Upper	Blob	9	The upper case conversion table.
Lower	Blob	9	The lower case conversion table.
NumContractions	Integer	4	The number of contraction pairs that exist in the collation.
Contractions	Blob	9	The contraction information if applicable.
AllowMultiple	Logical	1	Flag that indicates whether the collation table can be used at the same time as other collation tables on a given DBF or ADT table.

Remarks

sp_GetCollationTable retrieves a single collation table entry from adscollate.adt. It is primarily intended for internal usage. An application should not need to use this procedure. At this time, the collation information that is returned is not documented.