Name
serialize_to_UTF8_xml — Converts argument to its UTF-8 string representation.
Synopsis
serialize_to_UTF8_xml
(
|
in
value
any
); |
Description
The function converts its argument to a narrow string in UTF-8 encoding. The way conversion is done depends on the type of the argument.
If value
is a wide (national) string
or a LONG NVARCHAR then it is directly converted to UTF-8 string.
If value
is a string or a LONG VARCHAR
then it is converted from current charset of client connection to the UTF-8.
If value
is an XML entity then it is
converted to its XML text representation in UTF-8 encoding. The resulting
string is a well-formed XML document if the given entity is an element entity,
otherwise it may be well-formed generic entity, i.e. it can be parsed by
an XML parser only as a part of some other XML document.
If value
is NULL, the NULL is returned.
Values of other types are first converted to VARCHAR, this intermediate VARCHAR is converted from current charset of client connection to the UTF-8 and is returned.
Parameters
value
The value of arbitrary type to be converted into its UTF-8 string representation.
Return Types
UTF-8 string or NULL.
Examples
Example 24.369. UTF-8 encoding of non-ASCII characters
A sample document is parsed and the resulting entity is serialized to UTF-8 string.
select serialize_to_UTF8_xml(xtree_doc('<text>0-9 a-z A-Z €-ÿ Ā-ǿ Ѐ-῿</text>'));
callret
VARCHAR
_______________________________________________________________________________
<text>0-9 a-z A-Z -ÿ - - </text>