![]() Previous |
![]() Next |
TEXT
and NTEXT
data are interchangeable in most cases. However, implicit conversion can occur, such as when an NTEXT
value is assigned to a TEXT
variable. When TEXT
is converted to NTEXT
, no data loss occurs because the UTF-8 character encoding of the NTEXT
data type encompasses most other data types. However, when NTEXT
is converted to TEXT
, data loss occurs when NTEXT
characters are not represented in the workspace character set.
When TEXT
and NTEXT
values are used together, for example in a call to the JOINCHARS
function, the TEXT
value is converted to NTEXT
and an NTEXT
value is returned.