Oracle数据库字符集问题

新增

nls_lang
AMERICAN_AMERICA.AL32UTF8
Insert into tb_lottery_award
  (GAME_ID,
   PERIOD,
   WINNING_NUMBER,
   CREATE_TIME,
   TOTAL_POOL,
   TOTAL_SALES,
   UPDATE_TIME,
   EXTRA)
values
  ('2010042712YX00116975',
   '2013351',
   '7 2 6',
   to_timestamp('24-DEC-13 08.40.11.000000000 PM',
                'DD-MON-RR HH.MI.SS.FF AM'),
   0,
   49368358,
   to_timestamp('24-DEC-13 08.40.11.000000000 PM',
                'DD-MON-RR HH.MI.SS.FF AM'),
   '0 1 6');
   
select to_timestamp('24-DEC-13 08.40.11.000000000 PM','DD-MON-RR HH.MI.SS.FF AM') from dual;        
select to_timestamp('24-DEC-13 08.40.11.000000000 PM','DD-MON-RR HH.MI.SS.FF AM') from dual;
select to_char(sysdate, 'DD-MON-RR') from dual;
alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss';