Implementing Multiple Languages > Multiple-Language Overview > Locale Data
  
Locale Data
Information on language, country code, and, optionally, the variant is maintained in the locale.dat file, along with date and numeric formats. The system uses this information to set the locale formatting (the date and number formats) for an QAD Standard Edition user.
When a user logs in, the system validates the log-in identifier in User Maintenance and determines the associated QAD ERP (MFG/PRO) language and country code. It uses this information to access the corresponding record in locale.dat.
The system uses the date and number format information and ISO language code in locale.dat to set the user’s locale formats in character and in the QAD .NET UI.
If locale information cannot be determined at log-in, US settings are used by default.
Setting Different Locale Formats
Three values associated with a user determine locale formatting: language, country code, and variant.
1 Define country codes and corresponding ISO country code values in Country Code Maintenance (2.14.1):
a Specify the QAD ERP (MFG/PRO) country code (up to three letters) in the Country Code field.
b Specify the corresponding ISO code in the Alternate Code field.
ISO country codes are already defined in Generalized Codes Maintenance (36.2.13). If a code is not available in generalized codes, you can add it. Valid ISO country codes can be found on the following Web site:
http://www.chemie.fu-berlin.de/diverse/doc/ISO_3166.html
2 Create or update the user profile in User Maintenance (36.3.18; 36.3.1 in eB2.1).
a Specify the user’s language in the Language field.
b Specify the user’s country in the Country Code field. The system uses the alternate code to determine the ISO country code value.
c Optionally, specify a value in the Variant field.
3 Verify that the required locale entry is available in locale.dat file.
4 If necessary, use any standard text editor to edit the file and add or update entries, using the proper format; then save the file.
Locale Record Format
The format of records in locale.dat is as follows:
US,en,US,,mdy,American
Where:
US is the QAD ERP (MFG/PRO) language code.
en is the ISO language code.
US is ISO country code.
Optional variant is blank (indicated by ,,).
mdy (month/day/year) is the date format.
American is the numeric format (period as the decimal separator; comma as the thousand separator).
Two number formats are defined in Progress: American and European. Decimal and thousand separators are defined differently for each numeric format type. Periods (.) and commas (,) are used to separate decimal places and thousand places, depending on which format is specified. For example, in the US format, a period separates decimal, while a comma separates thousands as in 10,000.33. A user with the European numeric format will see the number as 10.000,33.
Language Codes and Country Codes
Language Codes lists QAD (MFG/PRO) language codes and the ISO language and country codes to which they map.
ISO language codes are lowercase and country codes are uppercase. Java is case sensitive and expects the codes in the ISO format.
Language Codes
 
Language
MFG/PRO
Language Code
ISO Language Code
ISO Country Code
Country
Chinese (Traditional)
TW
zh
TW
Taiwan
Chinese (Simplified)
CH
zh
CN
China
Czech
CZ
cs
CZ
Czech Republic
Dutch
DU
nl
NL
Netherlands
French
FR
fr
FR
France
German
GE
de
DE
Germany
Italian
IT
it
IT
Italy
Japanese
JP
ja
JP
Japan
Portuguese
PO
pt
BR
Brazil
Russian
RU
ru
RU
Russian
Spanish (Castilian)
CS
es
ES
Spain
Spanish (Latin)
LS
es
MX
Mexico
US English
US
en
US
GB
AU
United States
Great Britain
Australia