|
<< Click to Display Table of Contents >> Language drivers |
  
|
|
<< Click to Display Table of Contents >> Language drivers |
|
A language driver (LD) specifies a particular primary (or native) character set, as well as a country/language-dependent set of rules for character manipulation, such as sorting, upper- and lowercasing, and the set of characters that are considered alphabetic. A language driver's primary character set is the character set in which its rules are defined. It specifies sorting and uppercasing in terms of the code points used by that particular code page. It also defines the character translation mapping between its primary character set and the ANSI code page, when necessary. (For a complete list of available language drivers and their primary character sets, use DbiOpenLdList.)
Long name |
Short name |
Character set |
Collation sequence |
'ascii' ANSI |
DBWINUS0 |
1252 (ANSI) |
Binary |
'Spanish' ANSI |
DBWINES0 |
1252 (ANSI) |
Spanish |
'WEurope' ANSI |
DBWINWE0 |
1252 (ANSI) |
Multilingual Western Europe |
Access General |
ACCGEN |
1252 (ANSI) |
Access Western Europe |
Access Nord/Danish |
ACCNRDAN |
1252 (ANSI) |
Access Norwegian/Danish |
Access Swed/Finnish |
ACCSWFIN |
1252 (ANSI) |
Access Swedish/Finnish |
Access Japanese |
ACCJAPAN |
DOS 932 |
Access Japanese |
Borland DAN Latin-1 |
BLLT1DA0 |
1252 (ANSI) |
Danish |
Borland DEU Latin-1 |
BLLT1DE0 |
1252 (ANSI) |
German |
Borland ENG Latin-1 |
BLLT1UK0 |
1252 (ANSI) |
English/UK |
Borland ENU Latin-1 |
BLLT1US0 |
1252 (ANSI) |
Binary |
Borland ESP Latin-1 |
BLLT1ES0 |
1252 (ANSI) |
Spanish |
Borland FIN Latin-1 |
BLLT1FI0 |
1252 (ANSI) |
Finnish |
Borland FRA Latin-1 |
BLLT1FR0 |
1252 (ANSI) |
French |
Borland FRC Latin-1 |
BLLT1CA0 |
1252 (ANSI) |
French Canadian |
Borland ISL Latin-1 |
BLLT1IS0 |
1252 (ANSI) |
Isalandic |
Borland ITA Latin-1 |
BLLT1IT0 |
1252 (ANSI) |
Italian |
Borland NLD Latin-1 |
BLLT1NL0 |
1252 (ANSI) |
Dutch |
Borland NOR Latin-1 |
BLLT1NO0 |
1252 (ANSI) |
Norwegian |
Borland PTG Latin-1 |
BLLT1PT0 |
1252 (ANSI) |
Portogese |
Borland SVE Latin-1 |
BLLT1SV0 |
1252 (ANSI) |
Swedish |
dBASE CHS cp936 |
DB936CN0 |
DOS CODE PAGE 936 |
dBASE China |
dBASE CHT cp950 |
DB950TW0 |
DOS CODE PAGE 950 |
dBASE Taiwan |
dBASE CSY cp852 |
DB852CZ0 |
DOS CODE PAGE 852 |
dBASE Czech852 |
dBASE CSY cp867 |
DB867CZ0 |
DOS CODE PAGE 867 |
dBASE Czech867 |
dBASE DAN cp865 |
DB865DA0 |
DOS CODE PAGE 865 |
dBASE Danish |
dBASE DEU cp437 |
DB437DE0 |
DOS CODE PAGE 437 |
dBASE German |
dBASE DEU cp850 |
DB850DE0 |
DOS CODE PAGE 850 |
dBASE German850 |
dBASE ELL GR437 |
DB437GR0 |
DOS CODE PAGE 737 |
dBASE Greek |
dBASE ENG cp437 |
DB437UK0 |
DOS CODE PAGE 437 |
dBASE English/UK |
dBASE ENG cp850 |
DB850UK0 |
DOS CODE PAGE 850 |
dBASE English850/UK |
dBASE ENU cp437 |
DB437US0 |
DOS CODE PAGE 437 |
dBASE English/US |
dBASE ENU cp850 |
DB850US0 |
DOS CODE PAGE 850 |
dBASE English/US |
dBASE ESP cp437 |
DB437ES1 |
DOS CODE PAGE 437 |
dBASE Spanish |
dBASE ESP cp850 |
DB850ES0 |
DOS CODE PAGE 850 |
dBASE Spanish850 |
dBASE FIN cp437 |
DB437FI0 |
DOS CODE PAGE 437 |
dBASE Finnish |
dBASE FRA cp437 |
DB437FR0 |
DOS CODE PAGE 437 |
dBASE French |
dBASE FRA cp850 |
DB850FR0 |
DOS CODE PAGE 850 |
dBASE French850 |
dBASE FRC cp863 |
DB863CF1 |
DOS CODE PAGE 863 |
dBASE Canadian-French863 |
dBASE HUN cp852 |
DB852HDC |
DOS CODE PAGE 852 |
dBASE Hungarian |
dBASE ITA cp437 |
DB437IT0 |
DOS CODE PAGE 437 |
dBASE Italian |
dBASE ITA cp850 |
DB850IT1 |
DOS CODE PAGE 850 |
dBASE Italian850 |
dBASE JPN cp932 |
DB932JP0 |
DOS CODE PAGE 932 |
dBASE Japan932 |
dBASE JPN Dic932 |
DB932JP1 |
DOS CODE PAGE 932 |
dBASE JapanDic932 |
dBASE KOR cp949 |
DB949KO0 |
DOS CODE PAGE 949 |
dBASE Korea |
dBASE NLD cp437 |
DB437NL0 |
DOS CODE PAGE 437 |
dBASE Dutch |
dBASE NLD cp850 |
DB850NL0 |
DOS CODE PAGE 850 |
dBASE Dutch850 |
dBASE NOR cp865 |
DB865NO0 |
DOS CODE PAGE 865 |
dBASE Norwegian |
dBASE PLK cp852 |
DB852PO0 |
DOS CODE PAGE 852 |
dBASE Polish852 |
dBASE PTB cp850 |
DB850PT0 |
DOS CODE PAGE 850 |
dBASE Brazilian Portuguese 850 |
dBASE PTG cp860 |
DB860PT0 |
DOS CODE PAGE 860 |
dBASE Brazilian Portuguese 860 |
dBASE RUS cp866 |
DB866ru0 |
DOS CODE PAGE 866 |
dBASE Russian |
dBASE SLO cp852 |
DB852SL0 |
DOS CODE PAGE 852 |
dBASE Slovac |
dBASE SVE cp437 |
DB437SV0 |
DOS CODE PAGE 437 |
dBASE Swedish |
dBASE SVE cp850 |
DB850SV1 |
DOS CODE PAGE 850 |
dBASE Swedish850 |
dBASE THA cp874 |
DB874TH0 |
DOS CODE PAGE 874 |
dBASE Thai |
dBASE TRK cp857 |
DB857TR0 |
DOS CODE PAGE 857 |
dBASE Turkish |
DB2 SQL ANSI |
DB2ANDEU |
1252 (ANSI) |
Dictionary |
FoxPro German 437 |
FOXDE437 |
DOS CODE PAGE 437 |
FoxPro German |
FoxPro Nordic 437 |
FOXNO437 |
DOS CODE PAGE 437 |
FoxPro Nordic |
FoxPro Nordic 850 |
FOXNO850 |
DOS CODE PAGE 850 |
FoxPro German |
FoxPro German 1252 |
FOXDEWIN |
1252 (ANSI) |
FoxPro German |
FoxPro Nordic |
FOXNOWIN |
1252 (ANSI) |
|
Hebrew dBASE |
DBHEBREW |
dBASE Hebrew |
|
Oracle SQL WE850 |
ORAWE850 |
DOS CODE PAGE 850 |
Multilingual Western Europe |
Paradox 'ascii' |
ascii |
DOS CODE PAGE 437 |
Binary |
Paradox 'hebrew' |
hebrew |
DOS CODE PAGE 862 |
Hebrew |
Paradox 'intl' |
intl |
DOS CODE PAGE 437 |
Multilingual Western Europe |
Paradox 'intl' 850 |
intl850 |
DOS CODE PAGE 850 |
Brazilian Portuguese, French Canadian |
Paradox 'nordan' |
nordan |
DOS CODE PAGE 865 |
Norwegian/Danish (Paradox 3.5) |
Paradox 'nordan40' |
nordan40 |
DOS CODE PAGE 865 |
Norwegian/Danish (Paradox 4.0, 5.0, 5.5, 7.0) |
Paradox 'japan' |
japan |
DOS CODE PAGE 932 |
Japanese |
Paradox 'swedfin' |
swedfin |
DOS CODE PAGE 437 |
Swedish/Finnish |
Paradox 'turk' |
turk |
Turkish |
|
Paradox ANSI HEBREW |
ANHEBREW |
1255(ANSI) |
HebrewAnsi |
Paradox China 936 |
china |
DOS CODE PAGE 936 |
China |
Paradox Cyrr 866 |
cyrr |
DOS CODE PAGE 866 |
Cyrillic |
Paradox Czech 852 |
czech |
DOS CODE PAGE 852 |
Czech852 |
Paradox Czech 867 |
cskamen |
DOS CODE PAGE 867 |
Czech867 |
Paradox ESP 437 |
SPANISH |
DOS CODE PAGE 437 |
Spanish |
Paradox Greek GR437 |
grcp437 |
DOS CODE PAGE 737 |
Greek |
Paradox Hun 852 DC |
hun852dc |
DOS CODE PAGE 852 |
Hungarian |
Paradox ISL 861 |
iceland |
DOS CODE PAGE 861 |
Icelandic |
Paradox Korea 949 |
korea |
DOS CODE PAGE 949 |
Korea |
Paradox Polish 852 |
polish |
DOS CODE PAGE 852 |
Polish |
Paradox Slovene 852 |
slovene |
DOS CODE PAGE 852 |
Slovene |
Paradox Taiwan 950 |
taiwan |
DOS CODE PAGE 950 |
Taiwan |
Paradox Thai 874 |
thai |
DOS CODE PAGE 874 |
Thai |
Pdox ANSI ISO L_2 CZ |
ANIL2CZW |
1250 (ANSI) |
|
Pdox ANSI Cyrillic |
ancyrr |
1251 (ANSI) |
Compatible with Paradox "cyrr" |
Pdox ANSI Czech |
anczech |
1250 (ANSI) |
Compatible with Paradox "czech" |
Pdox ANSI Greek |
angreek1 |
1253 (ANSI) |
Compatible with Paradox "greek" |
Pdox ANSI Hun. DC |
anhundc |
1250 (ANSI) |
Compatible with Paradox "hung" |
Pdox ANSI Intl |
ANSIINTL |
1252 (ANSI) |
Compatible with Paradox "intl" |
Pdox ANSI Intl850 |
ANSII850 |
DOS CODE PAGE 850 |
Compatible with Paradox "intl850" |
Pdox ANSI Nordan4 |
ANSINOR4 |
1252 (ANSI) |
Compatible with Paradox "nordan40" |
Pdox ANSI Polish |
anpolish |
1250(ANSI) |
Compatible with Paradox "polish" |
Pdox ANSI Slovene |
ansislov |
1250(ANSI) |
Compatible with Paradox "slovene" |
Pdox ANSI Spanish |
ANSISPAN |
1252(ANSI) |
Compatible with Paradox "SPANISH" |
Pdox ANSI Swedfin |
ANSISWFN |
1252(ANSI) |
Compatible with Paradox "swedfin" |
Pdox ANSI Turkish |
ANTURK |
1254(ANSI) |
Compatible with Paradox "turk" |
SQL Link ROMAN8 |
BLROM800 |
Roman-8 |
Binary |
Sybase SQL Dic437 |
SYDC437 |
DOS CODE PAGE 437 |
Sybase 437 dict. with case-sensitivity |
Sybase SQL Dic850 |
SYDC850 |
DOS CODE PAGE 850 |
Sybase 850 dict. with case-sensitivity |
pdx Czech 852 'CH' |
czechw |
DOS CODE PAGE 852 |
|
pdx Czech 867 'CH' |
cskamenw |
DOS CODE PAGE 867 |
|
pdx ANSI Czech 'CH' |
anczechw |
1250 (ANSI) |
|
pdx ISO L_2 Czech |
il2czw |
ISO8859-2 |
Default language driver settings are defined in the BDE configuration file (IDAPI.CFG). You can change these defaults using the BDE Administrator. If you can be certain that your application will not need to support character sets other than Windows ANSI, you can reduce the need for extra processing, such as character translation, by changing your language driver defaults to ANSI-based ones. Additionally, if your application will be working exclusively with data from a particular SQL server, it may be advantageous to reset local language driver defaults to the driver you have associated with the SQL database alias.
When a Paradox, dBASE, or FoxPro table is created, the default language driver's identification is stored in the table file header. The default language driver setting can be overridden at creation by specifying optional parameters to DbiCreateTable. The table's language driver will be used by BDE functions that manipulate character data, such as DbiSortTable, DbiAddIndex, and a variety of other functions such as DbiGetNextRecord, DbiGetPriorRecord, DbiSetRange, DbiSetToKey, DbiInsertRecord, and so on. A table's language driver can be changed after creation by using DbiDoRestructure. DbiDoRestructure does not translate table data or metadata to the character set of the new language driver, in cases where the character sets of the old and new language drivers differ. However, table data is transliterated between differing character sets by DbiBatchMove.
For SQL table driver types, such as Sybase or Oracle, language driver settings are defined with the database alias in the BDE configuration file (IDAPI.CFG). All of the above operations when applied to SQL tables are governed by this setting.
To obtain the name of a table's language driver or the name of the default LD for a specific table driver, use the function DbiGetLdName.
The following table summarizes the default settings for language drivers.
Language driver for |
Default Setting |
System |
System language driver setting current in IDAPI.CFG. |
Access driver |
Access language driver setting current in IDAPI.CFG. |
Paradox driver |
Paradox language driver setting current in IDAPI.CFG. |
dBASE driver |
dBASE language driver setting current in IDAPI.CFG. |
Text driver |
System language driver. |
SQL database |
LANGDRIVER setting for this database current in IDAPI.CFG. |
SQL drivers |
LANGDRIVER setting in DB OPEN section of IDAPI.CFG for this driver. |
Table cursor |
Language driver associated with this table at the time it was created. |
Database handle |
Language driver of the database this handle represents. |
| Note: | You can override all defaults by using DbiSetProp. |