Unicode Coercion
Ingres coerces between Unicode data types and non-Unicode data types, including nchar/nvarchar and char/varchar types. Unicode coercion includes the following features:
• Unicode and non-Unicode columns can be joined together in a query.
• The Ingres COPY statement (and by inference, COPYDB and UNLOADDB) can be executed to generate or load non-binary data files where a table contains at least one Unicode column.
• Query strings containing non-Unicode literals that reference Unicode columns are coerced to Unicode before the DBMS executes the query.