在unicode源表中读取的字符无法转换为非unicode表 [英] Character which was read in unicode source table is failing to get converted into non-unicode table
问题描述
分析
以上文字有。如果你在Notepad ++中看到这个值,那么这个文本在unicode表中,但现在当我们尝试将它存储在非unicode表中时,它无法存储。它无法进行数据转换。源和目标的模式是相同的因此它是
不是问题。
The above text has . value if you see it in Notepad++ this text was in the unicode table but now when we are trying to store it in non-unicode table it is failing to store.It fails data conversion . Schema of source and target are same hence it is not the issue .
有谁知道这个角色是什么?
Does anyone know what is this character ?
当我看下面的链接时,它说 - GSM字符集中不存在字符,强制使用Unicode编码
when I looked the below link it says -Character not present in GSM charset, forces to use Unicode encoding
https://www.textmagic.com/free-tools/unicode-detector
我必须解释这个字符是什么以及它为什么不存储在char列(非unicode列)
I have to explain what this character is and why is it not getting stored in char column ( non unicode column)
推荐答案
嗨NewDataEngineer,
Hi NewDataEngineer,
您的数据来源是什么?
处理您的情况的方法很少:
There are few ways to handle your situation:
- 将列的数据类型更改为NVARCHAR()。
- 删除Unicode"white-noise" SSIS中ETL过程中的字符。
- 可能要做其他事情,比如在数据的原始系统中采取行动。
这篇关于在unicode源表中读取的字符无法转换为非unicode表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!