You can translate the question and the replies:

case insensitive for querying view purpose

Hi Team, Can Denodo support this function, to make the view name case insensitive, eg. I have one exact view like : DERIVED_VIEW_A, and when query the view, I may write the query like: select * from "derived_view_a", or select * from "Derived_View_a", and it will fetch the data from DERIVED_VIEW_A. That means: exact view name is "DERIVED_VIEW_A", when run query: select * from "DERIVED_VIEW_A" = select * from "derived_view_a" = select * from "Derived_View_a" thanks.
user
28-05-2021 21:18:23 -0400

1 Answer

Hi, You can select 'Unicode - Case sensitive' or 'Restricted - Case insensitive' in Identifiers charset configuration in the Denodo Platform. I found the relevant info in the following manual. * [Identifiers Charset](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/server_configuration/identifiers_charset/identifiers_charset) of the Virutal DataPort Administration Guide. Hope this helps!
Denodo Team
01-06-2021 03:49:41 -0400
You must sign in to add an answer. If you do not have an account, you can register here