select getdatabaseencoding(); getdatabaseencoding --------------------- UTF8 (1 row) set lc_time to 'Turkish_Turkey.1254'; SET select to_char(date '2010-02-01','DD TMMON YYYY'); to_char ------------- 01 ŞUB 2010 (1 row)