The problem of garbled sqlplus display in oracle terminal
Sqlplus login Oracle server query table shows in Chinese? Garbled code
SQL > select * from test11
ID
-
NAME
one hundred and eleven
??
two hundred and twenty two
??
three hundred and thirty three
?
SQL > select userenv ('language') from dual
USERENV ('LANGUAGE')
AMERICAN_AMERICA.AL32UTF8
[oracle@fx ~] $export NLS_LANG= "AMERICAN_AMERICA.AL32UTF8"
SQL > insert into test11 values (334 'Zhang Dong')
1 row created.
SQL > select * from test11
ID NAME
--
334 Zhang Dong
111 Xiao Ming
222 Wu Ming
three hundred and thirty three
SQL > insert into test11 values (335'Wu Min')
1 row created.
SQL > select * from test11
ID NAME
--
334 Zhang Dong
335 Wu Min
111 Xiao Ming
222 Wu Ming
three hundred and thirty three
