In SQL Developer if I want to see sysdate in 'Bangla' language then do I need to use a UNICODE Bangla font? Here is my query and the result is like this:
select to_char(SYSDATE, 'DD-Month-YYYY','NLS_DATE_LANGUAGE=bangla') "Bangla Date" FROM dual;
Result: 09-¿¿¿¿¿¿¿¿¿¿-2016
What to do?
Does your database support Unicode? Check with
SELECT *
FROM V$NLS_PARAMETERS
WHERE PARAMETER IN ('NLS_CHARACTERSET', 'NLS_NCHAR_CHARACTERSET');
In case the characterset does not support unicode but the national characterset does, you could use
SELECT TO_NCHAR(SYSDATE, 'DD-Month-YYYY','NLS_DATE_LANGUAGE=bangla') "Bangla Date"
FROM dual;
In any case you must select a font which is capable to display these characters. You can use this page to verify: Local Font List, resp. Font Support for Unicode Block 'Bengali'
