Function documentationMAPCHAR(x,n,i) Locate this document in the navigation structure

 

MAPCHAR(x,n,i) is a string function that converts country-specific letters to a different format (e.g. German umlauts, French letters with a grave accent).

MAPCHAR(x,n,i) uses the MapChar set with the name i (mapchar set name) to convert the character string x (string specification). Only expressions that produce an alphanumeric value are permitted as string specifications. If you do not specify a MapChar set name, the MapChar set with the name DEFAULTMAP (defined for the ASCII code) is used.

The code on which the character string x is based and the code on which the implemented MapChar set is based must match.

The n parameter (unsigned integer) is optional; n specifies the maximum length of the result.

MAPCHAR(x,n,i)

x, n, i

Result of the MAPCHAR(x,n,i) function

MAPCHAR(x,i)

MAPCHAR(x,n,i), whereby n is the length of the character string x

MAPCHAR(x,i) x is a CHAR or VARCHAR column

MAPCHAR(x,n,i), whereby n is the length of the column x

MAPCHAR(x)

MAPCHAR(x,DEFAULTMAP)

x is a NULL value

NULL value

Example Example

The MAPCHAR function enables data to be sorted correctly, for example, if "ü" is to be treated as "ue" for sorting purposes. The MapChar set with the name DEFAULTMAP is used.

SELECT ...,MAPCHAR(<column_name>) sort,... FROM ... ORDER BY sort

End of the example.