ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / WLanguage properties / HFSQL properties
  • Identifiers of the language
  • Identifiers of countries
  • Variants
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
LanguageDescribed (Property)
In french: LangueDécrit
ODBCNative Connectors (Native Accesses)Not available with these kinds of connection
The LanguageDescribed property is used to set the language used to compare and sort Unicode items (Unicode Text item or Unicode Text Memo item). You can:
  • Find out the language parameters used for the comparisons and for the sort. This property can be used for a file defined in the data model editor or through programming. The modifications performed by the H.LanguageCreationUnicode variable are ignored. The date returned corresponds to the one specified when describing the item.
  • Define the parameters of the language used for the comparisons and for the sort (when the item is described through programming). This property is equivalent to the Language property.
Example
// Defines the sort language through programming
H.LanguageCreationUnicode = "FR" + TAB + "FR"
// Creates the data file
HCreation(Customer)
// Returns the language defined in the analysis
Trace("LanguageDescribed: " + Customer.LastNameFirstName.LanguageDescribed)
Syntax

Finding out the language parameters Hide the details

<Language parameters> = <Data file>.<Item>.LanguageDescribed
<Language settings>: Character string
Characteristics of the language that will be used for the comparisons and for the sort, in the following format:
<Language identifier> + TAB + <Country identifier> + TAB + <Variant>

If the language parameters have been defined in the analysis as being:
  • "Defined at creation", <Language parameters> will correspond to the hLanguageCreation constant (or to "##CREATION##"+TAB+"##CREATION##"+TAB+"##CREATION##").
  • "Binary sort", <Language parameters> will correspond to the hLanguageBinarySort constant (or to "##BINARY##"+TAB+"##BINARY##"+TAB+"##BINARY##").
  • "Fast sort (multilingual)", <Language parameters> will correspond to the hLanguageFastSort constant (or to "##FASTSORT##"+TAB+"##FASTSORT##"+TAB+"##FASTSORT##").
<Data file>: Character string
Name of the file used. This name was defined in the data model editor or with the File Description type.
<Item>: Character string
Name of the item used. This name is defined in the data model editor or with the Item Description type.
WINDEVWEBDEV - Server codeReports and QueriesUniversal Windows 10 AppiPhone/iPadIOS WidgetUser code (UMC)Ajax

Defining the language parameters (item described through programming) Hide the details

<Item>.LanguageDescribed = <Language settings>
<Item>: Character string
Name of the item used. This name is defined with the Item Description type.
<Language settings>: Character string
Characteristics of the language that will be used for the comparisons and for the sort, in the following format:
<Language identifier> + TAB + <Country identifier> + TAB + <Variant>

  • To use a binary sort, <Language parameters> must correspond to the hLanguageBinarySort constant (or to "##BINARY##"+TAB+"##BINARY##"+TAB+"##BINARY##").
  • To use a fast sort, <Language parameters> must correspond to the hLanguageFastSort constant (or to "##FASTSORT##"+TAB+"##FASTSORT##"+TAB+"##FASTSORT##").
Remarks

Identifiers of the language

The identifiers used for the languages are as follows:
Identifier - LanguageIdentifier - Language
AR - ArabicAS - Assamese
BE - ByelorussianBG - Bulgarian
CA - CatalanCS - Czech
DA - DanishDE - German
EL - Modern GreekEN - English
ES - SpanishET - Estonian
FA - FarsiFI - Finnish
FO - FaeroeseFR - French
GA - IrishGU - Gujarati
HE - HebrewHI - Hindi
HR - CroatianHU - Hungarian
ID - IndonesianIN - Indonesian
IS - IcelandicIT - Italian
IW - HebrewJA - Japanese
KK - KazakhKL - Greenlandic
KN - KannadaKO - Korean
LT - LithuanianLV - Latvian
MK - MacedonianMR - Marathi
MS - MalayMT - Maltese
NB - Norwegian bokmålNL - Dutch
NN - Norwegian nynorskOM - Galla
PA - PunjabiPL - Polish
PS - PatchoPT - Portuguese
RO - RomanianRU - Russian
SH - Latin SerbianSK - Slovakian
SL - SlovenianSQ - Albanian
SR - SerbianSV - Swedish
TA - TamilTE - Telugu
TH - ThaiTR - Turkish
UK - UkrainianVI - Vietnamese
ZH - Chinese

Identifiers of countries

The identifiers used for the countries are as follows:
Identifier - CountryIdentifier - CountryIdentifier - Country
AE - United Arab EmiratesAF - AfghanistanAL - Albania
AR - ArgentinaAT - AustriaAU - Australia
BA - Bosnia-HerzegovinaBE - BelgiumBG - Bulgaria
BH - BahrainBN - BruneiBO - Bolivia
BR - BrazilBW - BotswanaBY - Belarus
CA - CanadaCH - SwitzerlandCL - Chile
CN - ChinaCO - ColombiaCR - Costa Rica
CZ - Czech RepublicDE - GermanyDK - Denmark
DO - Dominican RepublicDZ - AlgeriaEC - Ecuador
EE - EstoniaEG - EgyptES - Spain
ET - EthiopiaFI - FinlandFO - Faroe Islands
FR - FranceGB - Great BritainGL - Greenland
GR - GreeceGT - GuatemalaHK - Hong Kong
HN - HondurasHR - CroatiaHU - Hungary
ID - IndonesiaIE - IrelandIL - Israel
IN - IndiaIQ - IraqIR - Iran
IS - IcelandIT - ItalyJO - Jordan
JP - JapanKE - KenyaKR - South Korea
KW - KuwaitKZ - KazakhstanLB - Lebanon
LT - LithuaniaLU - LuxembourgLV - Latvia
LY - LibyaMA - MoroccoMK - Macedonia
MO - MacauMT - MaltaMX - Mexico
MY - MalaysiaNI - NicaraguaNL - Netherlands
NO - NorwayNZ - New ZealandOM - Oman
PA - PanamaPE - PeruPH - Philippines
PL - PolandPR - Puerto RicoPT - Portugal
PY - ParaguayQA - QatarRO - Romania
RU - RussianSA - Saudi ArabiaSD - Sudan
SE - SwedenSG - SingaporeSI - Slovenia
SK - SlovakiaSV - El SalvadoreSY - Syria
TH - ThailandTN - TunisiaTR - Turkey
TW - TaiwanUA - UkraineUS - Unites States
UY - UruguayVE - VenezuelaVI - Virgin Islands of the United States
VN - Viet NamYE - YemenYU - Bosnia-Herzegovina
ZA - South AfricaZW - Zimbabwe

Variants

The variants are as follows:
VariantExplanation
PHONEBOOKVariant of German
POSIXVariant of English for the Unites States
TRADITIONALVariant of Spanish
DIRECTVariant of Hindi
STROKEVariant of Chinese from Taiwan
PINYINVariant of Chinese from China
Minimum version required
  • Version 14
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/08/2024

Send a report | Local help