Displaying Thai Buddha NLS_Calendar with American NLS_Date_Language

[Quoted] I am have difficulties displaying dates in the NLS_DATE_LANGUAGE I specify.

When

NLS_CALENDAR = Thai Buddha
NLS_DATE_FORMAT = DD-Month-YYYY
NLS_DATE_LANGUAGE = AMERICAN

select sysdate from dual;

SYSDATE

(where the _at_@$@# is the month written properly in Thai (I just cannot
display in this message)

However, the result should be

SYSDATE

(this is the correct date in Thailand and equivalent to 31-Oct-2003 in
the Gregorian Calendar)

Also, the statement

select to_char(sysdate, 'DD-Mon-YYYY', 'nls_date_language = american') from dual;

TO_CHAR(SYSDATE,'DD-'

So, it seems as if the NLS_DATE_LANGUAGE has no effect on the Thai Buddha Calendar. If I switch the calendar back to Gregorian I can use the NLS_DATE_LANGUAGE to switch between English, French, etc display of weekdays and months.

I see a few posts on Oracle's web site about having difficulties displaying "Asian Calendars" in western languages. No soultions were give..

Has anyone experienced this or have a work around.

Thanks,

Dan Received on Fri Oct 31 2003 - 10:18:42 CET