学做内账的网站,如何做网站计数器,WordPress偷模板,青白江区城乡和建设局网站在Oralce的某一個表中#xff0c;一個地址字段包含了全角的字符#xff0c;需要轉換為半角字符#xff0c;以便進一步處理。表名#xff1a;a包含全角字符的字段#xff1a;address編輯表結構#xff0c;添加一列#xff1a;address2在PLSQL中#xff0c;新建SQL窗口一個地址字段包含了全角的字符需要轉換為半角字符以便進一步處理。表名a包含全角字符的字段address編輯表結構添加一列address2在PLSQL中新建SQL窗口輸入update a set a.address2 (to_single_byte(a.address))執行提交即可。函數解釋轉換成半角函數to_single_byte(s)轉換成全角函數:to_multi_byte(s)以上這個to_single_byte(s)和to_multi_byte(s)函數發揮作用的前提是數據庫字符集包括單字節字符和多字節字符。我的另外一台數據庫安裝的是GBK字符集但是查看表的內碼發現表的數據是用unicode字符集存儲的暫時還未搞明白是怎么回事。。。。。如果數據庫不包含這些字符需要用repalce()函數分別手工去替換update a t set t.address replace(t.address,,A)update a t set t.address replace(t.address,,B)update a t set t.address replace(t.address,,C)update a t set t.address replace(t.address,,D)update a t set t.address replace(t.address,,E)update a t set t.address replace(t.address,,F)update a t set t.address replace(t.address,,G)update a t set t.address replace(t.address,,H)update a t set t.address replace(t.address,,I)update a t set t.address replace(t.address,,J)update a t set t.address replace(t.address,,K)update a t set t.address replace(t.address,,L)update a t set t.address replace(t.address,,M)update a t set t.address replace(t.address,,N)update a t set t.address replace(t.address,,O)update a t set t.address replace(t.address,,P)update a t set t.address replace(t.address,,Q)update a t set t.address replace(t.address,,R)update a t set t.address replace(t.address,,S)update a t set t.address replace(t.address,,T)update a t set t.address replace(t.address,,U)update a t set t.address replace(t.address,,V)update a t set t.address replace(t.address,,W)update a t set t.address replace(t.address,,X)update a t set t.address replace(t.address,,Y)update a t set t.address replace(t.address,,Z)update a t set t.address replace(t.address,,-)update a t set t.address replace(t.address,,0)update a t set t.address replace(t.address,,1)update a t set t.address replace(t.address,,2)update a t set t.address replace(t.address,,3)update a t set t.address replace(t.address,,4)update a t set t.address replace(t.address,,5)update a t set t.address replace(t.address,,6)update a t set t.address replace(t.address,,7)update a t set t.address replace(t.address,,8)update a t set t.address replace(t.address,,9)手工寫入這些好麻煩有沒有自動化的一點的辦法
