Package DE_EPAGES::Object::API::Table::Locale
interface for table Locale
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)
|