The following table describes the registry settings that are installed for the Xbase engine. They are located in the \HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft
\Jet\3.5\Engines\Xbase key of the Windows registry. None of these settings are required.
Setting |
Data type |
Default value |
Description |
|
CollatingSequence |
String |
ASCII |
The collating sequence for all dBASE tables created or opened using Microsoft Access. Possible values are ASCII and International. |
DataCodePage |
String |
OEM |
The character set in which string and Memo values are stored. Possible values are OEM and ANSI. If the value of this setting is OEM, string values are translated from ANSI to OEM prior to being stored in the Xbase table. In the same manner, data retrieved from Xbase tables are translated from OEM to ANSI before being returned. |
Deleted |
Boolean |
01 |
Determines how records marked for deletion are handled by Microsoft Jet. A value of 01 corresponds to the dBASE command SET DELETED ON and indicates never to retrieve or position on a deleted record. A value of 00 corresponds to the dBASE command SET DELETED OFF and indicates to treat a deleted record like any other record. |
Century |
Boolean |
00 |
Used for formatting the century component of dates in cases where date-to-string functions are used in index expressions. A value of 01 corresponds to the dBASE command SET CENTURY ON, and a value of 00 corresponds to the dBASE command SET CENTURY OFF. |
Date |
String |
MDY |
The date formatting style to use in cases where date-to-string functions are used in index expressions. The possible values for this setting, which correspond to the dBASE SET DATE command, are American, ANSI, British, French, DMY, German, Italian, Japan, MDY, USA, and YMD. |
Mark |
Integer |
0 |
The decimal value of the ASCII character used to separate date parts. |
Exact |
Boolean |
00 |
Used for date comparisons. A value of 01 corresponds to the dBASE command SET EXACT ON. A value of 00 corresponds to the dBASE command SET EXACT OFF. |
KanjiStr |
Boolean |
00 |
00 means to treat strings as simple byte arrays. 01 means to treat strings as DBCS character strings. The KanjiStr setting is equivalent to the dBASE command SET KANJISTRING = ON. It affects the operation of the LEFT(), RIGHT(), SUBSTR(), AT(), REPLICATE(), and STUFF() functions inside the dBASE engine. A setting of 01 is recommended for DBCS countries. |