Notes on XML Types and Unicode Display in the Results Editor
Go Up to Using the Results Editor
When viewing data in the Results grid, keep the following in mind:
- XML data types are supported for IBM DB2 for Windows, Unix, and Linux, Microsoft SQL Server, and Oracle. In the Results grid, XML data types are displayed as LOB content.
- Support for display of Unicode characters is provided as follows:
- IBM DB2 for Windows, Unix, and Linux V8 and V9: character, clob, varchar, and longvarchar types
- SQL Server 2005: nchar, nvarchar, ntext, and nvarchar(max) types
- Oracle 9i, and 10g: NCHAR, NVARCHAR2 and NCLOB for non-Unicode UTF8 Character Set Instances and NCHAR, NVARCHAR2, CHAR, VARCHAR2, LONG, NCLOB and CLOB for Unicode UTF8 Character Set Instances
- Sybase ASE 12.5 and 15.2: UNICHAR,UNIVARCHAR and UNITEXT for non-Unicode UTF8 Character Set Instances and UNICHAR, UNIVARCHAR, UNITEXT, NCHAR, NVARCHAR, CHAR, VARCHAR and TEXT for Unicode UTF8 Character Set Instances