Virtual DataPort supports Unicode characters in the name of most of its elements: databases, user names, roles, data sources, wrappers, views, fields, etc.
By default, the Unicode support is disabled so any new element will be created with a “Restricted” character set. In this “Restricted” mode, the Server has the following behavior:
- The identifiers of elements (user names, data sources, wrappers, views, etc.) can only contain the characters specified in the definition of <identifier>:
- <identifier> = [A-Za-z\200-\377][A-Za-z\200-\377_0-9\$]*
- The identifiers of elements are case insensitive.
- E.g. the query SELECT * FROM INCIDENCES is equivalent to SELECT * FROM incidences.
- When creating an element, it will be stored with lowercase.
So, if a new user is created, for example, with the login “USER1”, it will be stored as “user1” and using “USER1” to connect to the server will throw the error “The username or password is incorrect”.
If it is required to create elements with uppercase or special characters, the Unicode mode can be enabled for the entire Server or just for some of its databases. When the Server or a database is in Unicode mode, the Server has the following behavior:
- The identifiers of elements (data sources, wrappers, views and their fields, etc.) can contain any character. To create elements in Unicode mode their names have to be surrounded with double quotes (“).
- For example: CREATE VIEW “例” AS... or SELECT * FROM “例”.
- The identifiers of elements (data sources, wrappers, views and their fields, etc.) may be case-sensitive or not. This depends on how the elements are created:
- The name is surrounded by double quotes (“) and at least one character is uppercase.
- At least one character of element’s name does not meet the definition of <identifier>
- The name is not surrounded by double quotes (“).
- The name is surrounded by double quotes (“) but all the characters meet the definition of <identifier> and they are lowercase.
When using the VDP Administration Tool to create, modify or rename elements, the Tool transparently surrounds the name of the element with `, unless all its characters are lowercase.
The identifiers charset can be switched between “Restricted” and “Unicode” for a specific database or the whole server:
- Select the database in the menu Administration > Database Management and click the Edit button after selecting the database to configure.
- From the same menu, new databases can be created and the charset can be selected in the creation window.
- From the menu Administration > Server Configuration > Identifiers charset.