从MS SQL Server R2表中读取土耳其语 [英] Read Turkish from MS SQL server R2 table

问题描述

我在MS SQL Server 2008 R2方面没有太多经验，但是如果您能帮助我，这就是问题所在:
我有一个带有列/字段(类型:nvarchar)的表，用于存储文本.使用vb.net应用程序从文本文件读取文本并将其写入数据库.
文本文件中的文本包含土耳其语字符，例如u，顶部带有2个点(将来会以不同的语言显示)
当我打开表格时，列中的文本不可读.它将土耳其语特殊字符转换为一些不可读的字符.
无论如何，可以使表格中的文本可读吗?
非常感谢.

I don''t have much experience with MS SQL server 2008 R2 but here is the issue if you would help me please:
I have a table with a column/field (type : nvarchar) that stores text. The text is read from a text file and written to the database using vb.net application.
The text in the text file contains Turkish characters such as the u with 2 dots on top(in the future it will be in different languages )
When I open the table, the text in the column is not readable. It converts the Turkish special character to some unreadable characters.
Is there anyway to make the text readable in the table?
Thank you so much.

推荐答案

文本文件的前三个字节显示了编码.从您描述的症状来看，编码不是unicode，而是一种特殊的编码(Windows-1250或类似的东西).
在将数据存储到数据库之前，VB应用程序必须将文本从该编码转换为unicode.

The first three bytes of the text files show the encoding. From the symptoms you describe, the encoding is not unicode, but a specialized encoding (Windows-1250 or something like that).
The VB application must convert the text from that encoding to unicode before storing the data in the database.

这篇关于从MS SQL Server R2表中读取土耳其语的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！