G. Features Introduced in Ingres 9.0 (Ingres 2006) : Changes to Existing Features : Enhanced Unicode Support : Unicode Coercion
 
Share this page                  
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.