中文字符加载不正确 [英] Chinese characters not loading properly

问题描述

大家好，





我尝试使用SSIS Package将值从oracle DB导出到SQL server DB。在oracle DB中包含一些中文字符无法正确加载的汉字。

它看起来与oracle不同。所以你可以请任何一个帮助

Hi All,


I try to export values from oracle DB to SQL server DB using SSIS Package.In the oracle DB contains some Chinese characters that Chinese characters not loading properly .
It looks like different from oracle .So can u please any one help

推荐答案

请看我对这个问题的评论。我们无法根据您的信息解决此问题。但是，我可以建议一些你可以检查的项目。

• 你可以使用一些不基于的编码用于中文文本的Unicode，已过时。
• 您可以在SQL中使用非Unicode数据类型。
  
  请参阅： https://technet.microsoft.com/en-us/library/ms191200%28v=sql.105%29.aspx 。
• 您可以将Unicode数据转码为其他编码，例如ASCII;即使表示编码可以基于Unicode，对于非Unicode编码不支持的代码点，Unicode字符也可以用'？'替换。
  
  （无论如何，你没有解释文本的位置错误地以及以何种方式。）
• 您可以选择不支持Unicode代码点的中文子集的字体。
• 这可能是其他一些问题，可能是基于对如何不了解Unicode工作以及如何在一种或另一种技术中支持它。
  
  请参阅：
  
  http://en.wikipedia.org/wiki/Unicode ，
  
  http://www.unicode.org 。

Please see my comment to the question. We cannot solve this problem based on your information. However, I can suggests some items you could check up.

• You could use some encoding not based on Unicode for your Chinese texts, something obsolete.
• You could use non-Unicode data types in SQL.
  Please see: https://technet.microsoft.com/en-us/library/ms191200%28v=sql.105%29.aspx.
• You could trans-code Unicode data to some other encoding, such as ASCII; even though presentation encoding could be based on Unicode, Unicode characters could be replaced with '?' for code points not supported by that non-Unicode encoding.
  (Anyway, you did not explain where the texts were mangled and in what way.)
• You could choose a font no supporting Chinese subset of Unicode code points.
• It could be some other problem, presumably based on lack of understanding of how Unicode works and how it is supported in one or another technology.
  Please see:
  http://en.wikipedia.org/wiki/Unicode,
  http://www.unicode.org.

这篇关于中文字符加载不正确的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！