Locale-specific data formatting
When a C UDR handles strings that contain display formats for date, time, numeric, or monetary data, you must write the UDR so that it handles any locale-specific formats of these display formats.
The DataBlade® API provides functions that convert between the internal representation of several data types and its display format.
The following DataBlade API functions
convert an internal database value to a string that uses the locale-specific
display format.
| DataBlade API function | Description |
|---|---|
| mi_date_to_string() | Uses the locale-specific display date format to convert an internal DATE value to its string equivalent. |
| mi_money_to_string() | Uses the locale-specific display monetary format to convert an internal MONEY value to its string equivalent. |
| mi_decimal_to_string() | Uses the locale-specific display numeric format to convert an internal DECIMAL value to its string equivalent. |
Important: The mi_datetime_to_string() and mi_interval_to_string() functions
do not format strings in the date and time formats of the current
processing locale. Instead, they create a date, time, or interval
string in a fixed ANSI SQL format.
The following DataBlade API functions
interpret a string in its locale-specific display format and convert
it to its internal database value.
| DataBlade API function | Description |
|---|---|
| mi_string_to_date() | Converts a string in its locale-specific date display format to its internal DATE format. |
| mi_string_to_money() | Converts a string in its locale-specific currency display format to its internal MONEY format. |
| mi_string_to_decimal() | Converts a string in its locale-specific numeric display format to its internal DECIMAL format. |
Important: The mi_string_to_datetime() and mi_string_to_interval() functions
do not interpret the date and time formats of the current processing
locale. Instead, they interpret the date/time or interval string in
a fixed ANSI SQL format.