3.5 Data Type Mappings

This section shows the mapping from eDirectory data types to SQL data types:

Table 3-6 Details of Data Type Mappings

eDirectory Attribute Syntax

Column Name

SQL Data Type

SYN_BACK_LINK

<attribute>_RemoteId

<attribute>_ObjName

SQL_INTEGER

SQL_VARCHAR

SYN_BOOLEAN

<attribute>

SQL_BIT

SYN_CE_STRING

<attribute>

SQL_VARCHAR

SYN_CI_LIST*

<attribute>

SQL_VARCHAR

SYN_CI_STRING

<attribute>

SQL_VARCHAR

SYN_CLASS_NAME

<attribute>

SQL_VARCHAR

SYN_COUNTER

<attribute>

SQL_INTEGER

SYN_DIST_NAME

<attribute>

SQL_VARCHAR

SYN_EMAIL_ADDRESS

<attribute>_Type

<attribute>_Addr

SQL_INTEGER

SQL_VARCHAR

SYN_FAX_NUMBER

<attribute>

SQL_VARCHAR

SYN_HOLD

<attribute>_ObjName

<attribute>_Amount

SQL_VARCHAR

SQL_INTEGER

SYN_INTEGER**

<attribute>

SQL_INTEGER

SYN_INTERVAL

<attribute>

SQL_INTEGER

SYN_NET_ADDRESS

<attribute>_AddrType

<attribute>_AddrLength

<attribute>_Addr

SQL_INTEGER

SQL_INTEGER

SQL_VARCHAR

SYN_NU_STRING

<attribute>

SQL_VARCHAR

SYN_OBJECT_ACL

<attribute>_ProtAttr

<attribute>_Privileges

<attribute>_Supervisor

<attribute>_Browse

<attribute>_Create

<attribute>_Delete

<attribute>_Rename

<attribute>_Compare

<attribute>_Read

<attribute>_Write

<attribute>_Add Self

<attribute>_Inheritable

SQL_VARCHAR

SQL_INTEGER

SQL_BIT

SQL_BIT

SQL_BIT

SQL_BIT

SQL_BIT

SQL_BIT

SQL_BIT

SQL_BIT

SQL_BIT

SQL_BIT

SYN_OCTET_LIST

Not Supported

SYN_OCTET_STRING**

<attribute>_Length <attribute>_Data***

SQL_INTEGER

SQL_VARCHAR

SYN_PATH**

<attribute>_NameSpace

<attribute>_Path

<attribute>_VolName

SQL_INTEGER

SQL_VARCHAR

SQL_VARCHAR

SYN_PO_ADDRESS

<attribute>_Name <attribute>_Street

<attribute>_POBox

<attribute>_City

<attribute>_State

<attribute>_Zip

SQL_VARCHAR

SQL_VARCHAR

SQL_VARCHAR

SQL_VARCHAR

SQL_VARCHAR

SQL_VARCHAR

SYN_PR_STRING

<attribute>

SQL_VARCHAR

SYN_REPLICA_POINTER

<attribute>_Server

<attribute>_Type

<attribute>_Number

<attribute>_Count

<attribute>_AddrType

<attribute>_AddrLength

<attribute>_Addr

SQL_VARCHAR

SQL_INTEGER

SQL_INTEGER

SQL_INTEGER

SQL_INTEGER

SQL_INTEGER

SQL_VARCHAR

SYN_STREAM

<attribute>

SQL_VARCHAR

SYN_TEL_NUMBER

<attribute>

SQL_VARCHAR

SYN_TIME

<attribute>

SQL_TIMESTAMP

SYN_TIMESTAMP

<attribute>_Time

<attribute>_EventId

SQL_TIMESTAMP

SQL_INTEGER

SYN_TYPED_NAME

<attribute>_ObjName

<attribute>_Level

<attribute>_Interval

SQL_VARCHAR

SQL_INTEGER

SQL_INTEGER

SYN_UNKNOWN

<attribute>_Name

<attribute>_SyntaxId

<attribute>_Length

<attribute>_Value

SQL_VARCHAR

SQL_INTEGER

SQL_INTEGER

SQL_VARCHAR

NOTE:* The strings in the Case Ignore List are placed in a single string with a comma separating the individual strings.

**Certain attributes with this syntax are specially interpreted by the ODBC driver.

***The data is presented in hexadecimal format.