linux下oracle乱码

export NLS_LANG="AMERICAN_AMERICA.AL32UTF8"

SELECT parameter, value FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET';

SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;
SHUTDOWN IMMEDIATE;
STARTUP;

SELECT * FROM nls_database_parameters WHERE parameter LIKE '%CHARACTERSET%';

SELECT CONVERT(column_name, 'AL32UTF8', 'ZHS16GBK') FROM table_name;

-- 查看当前字符集
SELECT parameter, value FROM nls_database_parameters WHERE parameter = 'NLS_CHARACTERSET';

-- 设置NLS_LANG环境变量（在客户端执行）
export NLS_LANG="AMERICAN_AMERICA.AL32UTF8"

-- 转换列的字符集
UPDATE employees SET name = CONVERT(name, 'AL32UTF8', 'ZHS16GBK');