Notes on XML Types and Unicode Display in the Results Tab

From RapidSQL
Jump to: navigation, search

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
Personal tools