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

1. View server-side coding

Select userenv ('language') from dual

Current return value: AMERICAN_AMERICA.ZHS16GBK

two。

Execute the statement select * from V$NLS_PARAMETERS

Check to see if the VALUE entry corresponding to NLS_LANGUAGE in the PARAMETER item in the first line is the same as the value obtained in the first step.

If not, you need to set the environment variable.

Otherwise, the PLSQL client-side code is inconsistent with the server-side code, and there will be garbled codes when inserting Chinese.

3.

Set environment variabl

Computer-> Properties-> Advanced system Settings-> Environment variables-> New system variables

Set the variable name: NLS_LANG, variable value: the value found in step 1 (mine is AMERICAN_AMERICA.ZHS16GBK).

4.

Restart PLSQL, insert data is normal

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.