Shulou(Shulou.com)06/01 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.