在sql中直接上传古吉拉特语文本 [英] directly upload of gujarati text in sql

问题描述

大家好，

我有一张Excel工作表，其中在古吉拉特语中使用"Nilkanth"字体键入了一些问题和答案.

我想要的是通过asp.net(C#)在sql server 2008中直接上载此Excel工作表
我在Windows 7中尝试过此操作，其中我使用Windows 7中可用的古吉拉特语工具键入excel表格，当我上传excel表格并且在sql中插入的数据正确时，但是在excel表格中我使用了字体并尝试上传它，它成功上传，但是文本在sql server 2008中不正确.

请帮助我解决这个问题...


预先感谢，
问候，
Krunal Panchal

Hello everyone,

I have one excel sheet in which there are some questions and answers in Gujarati typed using "Nilkanth" font.

what i want is to direct upload this excel sheet in sql server 2008 via asp.net (C#)
I have tried this in windows 7 in which i typed the excel sheet using gujarati language tool available in windows 7 , when i uploaded the excel sheet and the data inserted in sql was proper, but the excel sheet in which i used fonts and tried to upload it, it uploaded successfully but the text was not proper in sql server 2008.

Please help me in resolving this problem...


Thanks in advance,
Regards,
Krunal Panchal

推荐答案

如果使用Unicode，则应该了解，无论是否使用古吉拉特语脚本，字符串数据都与字体无关. Unicode支持大多数书写系统，并且默认情况下几乎所有现代平台都肯定支持古吉拉特语(代码指向0x0A81至0x0AEF)(与某些可能需要附加字体的更奇特的系统不同).
您没有在问题中提供足够的信息，但是可能的解决方法之一可能是:
http://support.microsoft.com/kb/239530 [ http://blogs.msdn.com/b/sqlcat/archive/2010/03/03/sql-server-2008-r2-unicode-compression-what-happens-in-the-background.aspx [ http://unicode.org/ [ ^ ]，
http://unicode.org/faq/utf_bom.html [

If you use Unicode, you should understand that string data, using Gujarati script or not, has nothing to do with fonts. Unicode support most of the writing systems and Gujarati (code points to 0x0A81 to 0x0AEF) is certainly supported by nearly all modern platforms by default (unlike some more exotic systems where additional fonts may be needed).

You don''t provide enough information in the question, but one of the possible resolutions could be this:
http://support.microsoft.com/kb/239530[^].

See also: http://blogs.msdn.com/b/sqlcat/archive/2010/03/03/sql-server-2008-r2-unicode-compression-what-happens-in-the-background.aspx[^].

Get better understanding of what Unicode is:
http://unicode.org/[^],
http://unicode.org/faq/utf_bom.html[^].

—SA

这篇关于在sql中直接上传古吉拉特语文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！