You can translate the document:


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.


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:




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.


Virtual DataPort Administration Guide: Identifiers Charset

Virtual DataPort Administration Guide: Creating Databases

Advanced VQL Guide: Unicode Identifiers

The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.


Ask a question

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