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 '????%'