Using unicode in VDB metadata DDL object names with the embedded server.

dnicodemus Mar 22, 2016 10:23 AM

We're using the embedded server, currently on version 8.11.2.

Does Teiid support unicode characters in the names of tables, views, constraints and fields ? Do the names have to be quoted in these cases ? What validations checks are their for legal names ? Any commonly known gotcha's ?

Thanks,

Dave

1. Re: Using unicode in VDB metadata DDL object names with the embedded server.

shawkins Mar 22, 2016 2:36 PM (in response to dnicodemus)

> Does Teiid support unicode characters in the names of tables, views, constraints and fields ?

Yes

> Do the names have to be quoted in these cases ?

No, that is optional.

> What validations checks are their for legal names ?

Unquoted names must begin with @ # or a letter and only contain letters, digits, or _. Letters may be any upper or lower case ascii letter or any unicode character in the range 0153-fffd. See the regex pattern for letter on BNF for SQL Grammar | Teiid Documentation

> Any commonly known gotcha's ?

Depending upon the client you can use the utf character directly or Teiid supports the escape syntax \uXXXX

If you find any issues just let us know.
Actions
2. Re: Using unicode in VDB metadata DDL object names with the embedded server.

dnicodemus Mar 22, 2016 3:01 PM (in response to shawkins)

Thanks Steven, if we find anything we'll let you know.
Actions

Go to original post