Unicode support

Applies to: Denodo 8.0 , Denodo 7.0 , Denodo 6.0
Last modified on: 12 May 2020
Tags: Case sensitivity Server configuration

Download document

You can translate the document:

Goal

This document describes how to configure Virtual DataPort to use Unicode characters in its elements’ names and rules that apply when Unicode support is enabled.

Content

Virtual DataPort supports Unicode characters in the names of most of its elements: databases, usernames, roles, data sources, wrappers, views and their fields, etc.

By default, Unicode support is disabled and can be enabled for the entire server or individual databases.

To enable Unicode support for the entire server, follow the steps described below:

  1. Click on Administration > Server configuration > Identifiers charset.
  2. Select the option Unicode – Case sensitive, and click Ok.
  3. Restart the Virtual DataPort server.

If you only want to enable Unicode support for an individual database, follow these steps:

  1. Click on Administration > Database Management.
  2. Select the database, and click on Edit.
  3. Select the Unicode - Case sensitive, and click Ok.

Once the Virtual DataPort server or an individual database has been configured to use Unicode characters, the following rules apply to the names of the different elements:

        

  • The identifiers of elements (e.g. data sources, wrappers, views and their fields, etc.) can contain any character.

<identifier> ::= { <basic identifier> | <quoted identifier> }

<basic identifier> ::= [A-Za-z\200-\377][A-Za-z\200-\377_0-9\$]*

     <quoted identifier> ::=

  ".*" (a double quote in an identifier has to be escaped with another double quote)

  • To create an element whose name does not meet the definition of <identifier> described above, you have to surround its name with double quotes. For example:

CREATE VIEW “例” AS ... 

or

SELECT * FROM “例”

Note: View names starting with _ are not supported.

  • The identifiers of elements (data sources, wrappers, views and their fields, etc.) may be case-sensitive or not depending on how the elements are created.

If an element is case-sensitive, you always have to surround its name with double quotes. For example:

SELECT * FROM “Incidences”

All function names, operator names, and VQL tokens (e.g. ANY) are always case-insensitive.

You cannot create elements of the same type with the same name but different case.

If you use Virtual DataPort Administration Tool to create, modify, or rename an element, the tool transparently surrounds the name of the element with  unless all its characters are lowercase.

References

Virtual DataPort Administration Guide: Identifiers Charset

Virtual DataPort Administration Guide: Creating Databases

Advanced VQL Guide: Unicode Identifiers

Questions

Ask a question
You must sign in to ask a question. If you do not have an account, you can register here

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training