ePages 6.10 - DE_EPAGES/Object/API/Table/Locale.pm

Package DE_EPAGES::Object::API::Table::Locale

interface for table Locale

@EXPORT_OK
GetInfoLocale
GetAllInfoLocales

Functions

GetAllInfoLocales
GetInfoLocale

GetAllInfoLocales

Returns all objects of Locale.

Syntax
$ahLocaleIDs = GetAllInfoLocales();
Return
$ahLocaleIDs (reference to array of hashes)
with following keys:
  • LocaleID - locale id, example en_GB (primary key)- varchar(5)
  • IsUsed - is locale used - bit
  • LanguageID - default language - int
  • CountryID - country id - int
  • CurrencyID - default currency - char(3)
  • DecimalSep - decimal seperator ('.' or ',') (optional)- nchar(1)
  • ThousandSep - thousend seperator (',' or '.'), character inserted between groups of 3 digits (optional)- nchar(1)
  • NegFormatNumbers - negative format (-x or x-) means if position of - in front or behind the number. x will be replaced by positive number. (optional)- varchar(10)
  • PosFormatCurrency - format for positive numbers, symbol in front of or behind number ('¤ x' or 'x ¤'), x will be replaced by number ¤ by currency symbol. (optional)- varchar(10)
  • NegFormatCurrency - format for negative numbers, symbol in front of or behind number ('-¤ x' or 'x ¤-'), x will be replaced by number ¤ by currency symbol. its only allowed to use '-' for negative numbers. (optional)- varchar(10)
  • ListColumnSeparator - list column separator (optional)- varchar(10)
  • ListRowSeparator - list row separator (optional)- varchar(10)
  • ListQuotCharacter - list quot character (optional)- nchar(1)
  • DefaultCharSet - default charset (optional)- varchar(50)

GetInfoLocale

Returns the Locale by identifier. Returns undef if the locale does not exist.

Syntax
$hLocale = GetInfoLocale($LocaleID);
Input
$LocaleID (varchar(5))
locale id, example en_GB (primary key)
Return
$hLocale (reference to hash)
with following keys:
  • LocaleID - locale id, example en_GB (primary key)- varchar(5)
  • IsUsed - is locale used - bit
  • LanguageID - default language - int
  • CountryID - country id - int
  • CurrencyID - default currency - char(3)
  • DecimalSep - decimal seperator ('.' or ',') (optional)- nchar(1)
  • ThousandSep - thousend seperator (',' or '.'), character inserted between groups of 3 digits (optional)- nchar(1)
  • NegFormatNumbers - negative format (-x or x-) means if position of - in front or behind the number. x will be replaced by positive number. (optional)- varchar(10)
  • PosFormatCurrency - format for positive numbers, symbol in front of or behind number ('¤ x' or 'x ¤'), x will be replaced by number ¤ by currency symbol. (optional)- varchar(10)
  • NegFormatCurrency - format for negative numbers, symbol in front of or behind number ('-¤ x' or 'x ¤-'), x will be replaced by number ¤ by currency symbol. its only allowed to use '-' for negative numbers. (optional)- varchar(10)
  • ListColumnSeparator - list column separator (optional)- varchar(10)
  • ListRowSeparator - list row separator (optional)- varchar(10)
  • ListQuotCharacter - list quot character (optional)- nchar(1)
  • DefaultCharSet - default charset (optional)- varchar(50)