sql语句as的中文乱码
1. 读取sql语句时sql中的中文变乱码如何解决 decode(d.rework_flag,'Y','正常作业','N','再作业') as rework_f
最简单的解决办法，页面用charset=utf-8
这样什么转换都不用应该就行了
2. Oracle：PL/SQL中用SQL语句添加数据 中文出现乱码问题[有图]
说明数据库不支持中文，修改为GBK或者Utf-8就可以了。
;改完编码后执行
sql>conn/assysdba;
sql>shutdownimmediate;
databaseclosed.
databasedismounted.
oracleinstanceshutdown.
sql>startupmount;
oracleinstancestarted.
fixedsize452044bytes
variablesize109051904bytes
databasebuffers25165824bytes
redobuffers667648bytes
databasemounted.
sql>;
systemaltered.
sql>altersystemsetjob_queue_processes=0;
systemaltered.
sql>altersystemsetaq_tm_processes=0;
systemaltered.
sql>alterdatabaseopen;
databasealtered.
sql>_useUTF-8;
sql>shutdownimmediate;
sql>startup;
查看数据库编码格式：select userenv('language') from al;
如果数据库格式支持中文，那么就要看下执行的sql是不是本身就有乱码了。
3. asp.net sql语句里面的中文变成乱码
你的网页编码应该与数据库的编码保持一致，比如数据库是UTF-8的，则网页也应该是UTF-8，如果是GB2312就会乱码了。
4. Sql server出现中文乱码怎么办
使用sqlserver有时会出现中文乱码，这多半是软件中编码设置造成了，只需要修改本地编码既可以解决问题。
方法：
1、登陆“Microsoft SQL Server Management Studio”，然后选择对应的数据库的属性，打开属性标签。
5. sql 语句 中文部分乱码
和sql没有关系，是数据库编码问题，最好的统一为utf-8，这里指的是数据库安装的时候编码问题，不是代码，直接用工具查询能够查询出数据，用代码调用SQL插入，就会出现乱码，查询出来也是乱码，都是数据库安装的时候 与开发的时候编码 不一致造成的。
6. sql语句select as中文为乱码
public List getOrganizationInfoByLikeName(
String likeName) throws UnsupportedEncodingException {
//String name = new String(likeName.getBytes("UTF-8"),"GBK");
String sql = "from OrganizationInfo org where org.name like '"+likeName+"%'";
return getHibernateTemplate().find(sql);
}
拼出来的sql条件语句字段是乱码导致查询不到记录，怎么处理？
Hibernate: select organizati0_.ID as ID, organizati0_.CODE as CODE10_, organizati0_.NAME as NAME10_, organizati0_.YJ_ORGANIZATION_CODE as YJ4_10_, organizati0_.LOGIC_CODE as LOGIC5_10_, organizati0_.ORG_TYPE as ORG6_10_, organizati0_.ORG_PERIOD_TYPE as ORG7_10_, organizati0_.PARENT_ORG_ID as PARENT8_10_, organizati0_.FITECH_FILLER as FITECH9_10_, organizati0_.FITECH_CHECKER as FITECH10_10_, organizati0_.FITECH_PRINCIPAL as FITECH11_10_, organizati0_.IS_DELETED as IS12_10_, organizati0_.conver_code1 as conver13_10_, organizati0_.conver_code2 as conver14_10_, organizati0_.conver_code3 as conver15_10_, organizati0_.ORG_FLAG as ORG16_10_, organizati0_.SUM_FLAG as SUM17_10_, organizati0_.RH_ORG_CODE as RH18_10_, organizati0_.RH_LOC_CODE as RH19_10_, organizati0_.RH_SYSTEM_CODE as RH20_10_, organizati0_.RHN_ORG_CODE as RHN21_10_, organizati0_.RHN_SYSTEM_CODE as RHN22_10_ from ORGANIZATION_INFO organizati0_ where organizati0_.NAME like '????%'