首页 \ 问答 \ 插入表格时，乌克兰字符会更改为问号(Ukrainian character change to question mark when insert to table)

插入表格时，乌克兰字符会更改为问号(Ukrainian character change to question mark when insert to table)

 我将文件保存为包含乌克兰字符的Unicode文本，并使用SSIS将它成功加载到登台表。  
 喜欢这个：  
"Колодки тормозные дисковые, комплект"
Колодки тормозные
"Колодки тормозные дисковые, комплект"
This is Test
 
 但是当我将它移动到其他表格时，它会更改为：  
"??????? ????????? ????????, ????????"
??????? ?????????
"??????? ????????? ????????, ????????"
This is Test
 
 我使用的查询：  
insert into finaltable
(
column1
)

select column1 from staging table.
 
 整理：Latin1_General_CI_AS  
 我该如何纠正这个错误？ 

I have a file saved as Unicode text containing Ukrainian characters, and it got loaded successfully to staging table using SSIS. 
Like this: 
"Колодки тормозные дисковые, комплект"
Колодки тормозные
"Колодки тормозные дисковые, комплект"
This is Test
 
But when I am moving it to other table it changes to: 
"??????? ????????? ????????, ????????"
??????? ?????????
"??????? ????????? ????????, ????????"
This is Test
 
The query I used: 
insert into finaltable
(
column1
)

select column1 from staging table.
 
Collation: Latin1_General_CI_AS 
How can I rectify this error?

原文：https://stackoverflow.com/questions/46196062

更新时间：2024-05-02 15:05

最满意答案

你在谈论两件不同的事情。
首先，Jython和IronPython是可以嵌入Java或C＃应用程序中以提供脚本功能的Python实现。 这减少了您必须编写的代码总量。 或者，您可以将它们看作一种粘合在一起并利用现有类库的集合的方式。 然而，你看它，这些都是好东西，很多人使用它们。
但睡衣是完全不同的。 它使你的web堆栈变得复杂，并且使得将项目传递给其他程序员变得更加困难。 主要的用例是如果你有一个Python程序员的商店，他们需要提供一个丰富的互联网应用程序客户端，但无法承担学习Javascript的时间。 没有广泛的用处。
另外，我个人的经验是，大多数Python程序员已经从构建Web应用程序中很好地了解了Javascript。 只是深入研究Javascript，它确实不是一个学习曲线。 我已经在Windows上将JSCRIPT脚本编写为批处理文件替换，并在众多网页中使用Jquery编写了一些JavaScript代码。 当我想为node.js学习服务器端JavaScript时，它真的只花了几个星期的时间来完成我对Javascript的知识。 在我看来，应该避免睡衣。 迟早，Javascript引擎将支持该语言的1.8版本，这大大缩小了大括号问题以外的语言之间的差距。

You are talking about two different things.
First, Jython and IronPython are Python implementations that you can embed in a Java or C# application to provide scripting capability. This reduces the amount of code that you have to write overall. Or you can look at them as a way to glue together and leverage an existing collection of class libraries. However you look at it, these are good things and lots of people use them.
But Pyjamas is something else entirely. It complicates your web stack and makes it harder to pass projects on to other programmers. The main use case is if you have a shop of Python programmers and they need to provide a rich Internet application client side but cannot afford the time to learn Javascript. Not as broadly useful.
Also, my personal experience is that most Python programmers already know Javascript reasonably well from building web apps. It really is not much of a learning curve to just dive into Javascript. I've written JSCRIPT scripts on Windows as a batch file replacement and bits of Javascript with Jquery in numerous web pages. When I wanted to learn server-side Javascript for node.js, it really only took a couple of weeks to round out my knowledge of Javascript. In my opinion, Pyjamas should be avoided. Sooner, rather than later, Javascript engines will be supporting version 1.8 of the language which greatly narrows the gap between the languages other than the curly braces issue.

插入表格时，乌克兰字符会更改为问号(Ukrainian character change to question mark when insert to table)

最满意答案

相关问答

什么是IronPython[2022-04-02]

Groovy优于Jython或Jruby？(Groovy advantages over Jython or Jruby?)[2023-02-23]

在Jython中出现(isinstance in Jython)[2023-04-19]

使用ARC有哪些优点和缺点？(What are the advantages and disadvantages of using ARC? [closed])[2022-08-10]

使用Jython / IronPython /睡衣有什么优点/缺点？(What are the advantages/disadvantages of using Jython/IronPython/Pyjamas?)[2022-07-10]

IronClad相当于Jython(IronClad equivalent for Jython)[2022-04-07]

StyleCop，优点/缺点(StyleCop, advantages/disadvantages)[2022-03-11]

可以从IronPython使用scikit吗？(Can scikit be used from IronPython?)[2023-04-26]

Ironpython：IEnumerator(Ironpython: IEnumerator)[2023-11-11]

Ironpython查询(Ironpython query)[2021-12-17]

相关文章

最新问答