ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / WLanguage variables
  • Language identifier
  • Identifier of the 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
H.LanguageCreationUnicode (Variable)
In french: H.CréationLangueUnicode
HFSQL ClassicHFSQL Client/ServerAvailable only with these kinds of connection
Allows you to define the characteristics of the sort for the Unicode items found in a data file. This variable must be used before creating the data files (HCreation and HCreationIfNotFound).
Example
H.LanguageCreationUnicode = "AR" + TAB + "MA"
Syntax
H.LanguageCreationUnicode(<Language characteristics>)
<Language characteristics>: Character string
  • Characteristics of the language that will be used for the sort, in the following format:
    <Language identifier> + TAB + <Country identifier> + TAB + <Variant>
  • Constant used to define a specific sort:
    hLanguageBinarySortThe sort will be performed by comparing the binary value of the bytes. This type of sort is very fast. It should be used to perform an exact-match search for example.
    hLanguageFastSortThe sort will be performed by comparing the characters one by one according to a generic sort.
Remarks

Language identifier

The identifiers used for the languages are as follows:
Language identifierLanguage identifier
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

Identifier of the countries

The identifiers used for the countries are as follows:
Country identifierCountry identifierCountry identifier
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:
Variant
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: 05/26/2022

Send a report | Local help