C# 连接ORACLE 出现乱码解决
1:先查询oralce的字符编码:select userenv('language') from dual;
2:在环境变量中设置NLS_LANG变量:
3:配置连接字符串:
Provider=OraOLEDB.Oracle;User ID=***;Password=***;Data Source=(DESCRIPTION = (ADDRESS_LIST= (ADDRESS = (PROTOCOL = TCP)(HOST = ***)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = ORCL)))
4:安装Oracle客户端:(可自行网上搜索下载)
5:需要的可用下载一个PLSQL工具