I want to set up a database (v 12.1.0.2) with NLS_CALENDAR parameter as 'Thai Buddha', at the same time I need to keep character set as ‘AL32UTF8’.
When I do this at setting up NLS_CALENDAR parameter does not get changed at DB level. 'SELECT SYSDATE FROM DUAL' return Current date in A.D (year is 2016, in Thai it should be 2559)
But if I alter the season and set NLS_CALENDAR parameter as 'Thai Buddha' 'SELECT SYSDATE FROM DUAL' returns date with year as 2559.
What really I want is a Database(v 12.1.0.2) with NLS_CALENDAR = 'Thai Buddha' and character set = ‘AL32UTF8’.
are there any specific guidelines I should follow to get this done? or are there any other parameters I should change?
Thank you in advance.