Notes on XML Types and Unicode Display in the Results Editor

From DBArtisan

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