原DB設為BIG5(SERVER_LOCALE=zh_TW.big5 ),而且已經在使用中，若想改為Unicode, 該如何處理？

INDEX 的排列是由 DB_LOCALE 決定的, 如歐洲語文, 所以要改 DB_LOCALE 的話, 必須重建database, 重新 import 才可以. 仲使是 中文的 locale 亦然

這樣子說明不就是指明，Unicode與BIG5無解
就算是重建DATABASE，原始BIG5資料也無法RESTORE至新設定Unicode的DB

就ifx來說，
重建DB當時便可指定新的字碼。


已經有內容部份，除了BLOB以外，可以透過 iconv 或是 ConverZ之類的軟體協助將原先EXPORT出來的資料轉碼。
不過轉碼之後可能字串長度會變長，必須一併考量欄位所需要的長度。

BLOB的部份可以依照需要先寫程式將之還原，在按照需要使用對應的程式進行 轉碼。

文章曾經由此用戶編輯: joe, 於: 2007/06/06 12:09

文章曾經由此用戶編輯: joe, 於: 2007/06/06 12:13

YES, 可以用 iconv 把 dbexport 的 .unl 檔內容轉為 unicode, 而 blob 資料會存成 blob* 的檔名, 這些 blob files 應該不用再轉, 可直接透過 dbimport 程序 insert 回新的 database

We are committed to offer the cheapest World of Warcraftgold or all wow gold our trusty customers with credible and professional service at goldofworldwarcraft.com.And has wow gold kaufen grown into a World of Warcraft has an excess of one runescape money million paying users in North America alone. Buy Wow gold is wow gold instant delivery World of Warcraft s unit of currency. We come across virtual rift plat goods being sold for several thousands of dollars in the World runescape gold of Warcraft game. When you buy gold wow it helps get buy wow gold your professions to a higher level. Even though there are instructional buy cheap runescape gold websites to teach players the methods of earning free wow gold, cheap wow gold a majority prefer to Buy world of warcraft gold to advance their virtual status in the game and the ease of buying instead of earning. But this can be a double-edged sword. Because when you Buy WoW Gold, it is against the Terms and Conditions of Blizzard Inc. A lot of wow players like it because it saves a lot of time though.