首頁

2013年11月16日 星期六

*SSIS由ORACLE轉成SQL..中文字型怎么弄出了>蕞蕞..拎此..<的字符來?!*找到解釋了!!*US-en* SSIS converted by the ORACLE SQL .. Chinese fonts how came up>> Tiny tiny .. carry this .. <'s character?! * Find explain!!*

*SSIS由ORACLE轉成SQL..中文字型怎么弄出了>
>蕞蕞..拎北..<的字符來*找到解釋了*
*US-en*>SSIC converted by the ORACLE SQL..Chinese fonts how came up蕞蕞..拎北..<'s character?!*Find explain !!*

*SSIS在ORACLE與SQL搬資料時的編碼問題
發現只有用特定的機器跑SSIS時會變亂碼.
想必應與機器上的本機設定有關,
在改過NLS_LANG後,亂碼-就消失了!*
程式下載(Ver 1.32)*

**分享介紹工具*在中文編碼解析工具加入這項新功能
(目前只支援Big5與簡體中文,應該夠用了),
推出Ver 1.3版,有需要的朋友可以下載回去玩玩喔!*
*en*ORACLE and SQL SSIS to move the data coding problem
Found that only a particular machine when running SSIS become garbled.
Presumably on the machine should be set on the machine,
In turn NLS_LANG, the garbage - is gone!
*

*程式下載(Ver 1.32)*
** Share Presentation Tools * In Chinese coding analysis tool  
 to add this new feature (currently only supports Big5 and Simplified Chinese, should be enough), launched Ver 1.3 version,  
 a friend in need can be downloaded back to play Oh!*

*為什麼不是出現無規則亂碼或問號,而是全都變成"蕞"呢?
利用中文編碼解析工具,查出"蕞"的BIG5編碼是%bf%bf,
而ASCII 0xBF = ¿,一個倒置的問號。看到這個符號,
應該有點印象吧?

編碼錯誤解析不出來時,常會出現�、?,但有時也會看到¿。
當中文完全無法解析,全都的文字都變成¿,
兩個¿接在一起,再被當成BIG5解析,就變成"蕞"了!

用以下的實驗證明,四個中文字變成¿¿¿¿,
再以BIG5解讀,就變成"蕞蕞"..!*

*


















*en*
Why not appear garbled or a question mark without rules, but all turned into "tiny"(蕞) mean?
The use of Chinese encoding analytic tools,

 found "tiny"(蕞) BIG5 encoding is% bf% bf,
The ASCII 0xBF = ¿, An inverted question mark. See this symbol,
It should be a little impression?

Coding error parsing does not come out, often appears?,

 But sometimes seen ¿.
When the Chinese can not be resolved completely,

 all the text have become ¿,
Two ¿Together, and then be treated as BIG5 resolved,

 it will become "tiny" (蕞)a!

With the following experiments show that four Chinese characters become ¿¿¿¿,
Then BIG5 interpretation, it will become "tiny tiny"(.蕞蕞 ..)!
*


=================THE     END==================>/

&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

沒有留言:

張貼留言


if you like make fds, wellcome you here~~anytime***

my free place for everyones who want the good software,

come & download them~ wellcome!!