问题描述
Hello,
我正在使用Web应用程序将数据发送到Oracle 12C数据库读取Excel文件。一切都工作得非常好,直到
用户尝试上传excel与瑞典字符,如"Å,å,Ä,ä,Ö,ö"。应用程序正在从Excel中读取瑞典字符并完美地存储变量。但是在检查Oracle方面时,我发现,它实际上存储的数据是奇怪的ASCII
字符 浏览次数:1
大小: 10.6 KB"border ="0"src ="http://www.vbforums.com/attachment.php?attachmentid=152099&d=1506139884"title ="姓名:Issue_01.jpg
浏览次数:1
大小:10.6 KB"style ="border:0px; max-width:100%;颜色:#333333; font-family:Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size:13px; background-颜色:#fafafa"> 。
我试图在Gridview上显示这个值,它完美地显示了瑞典字符。此外,我尝试使用StreamWriter将字符串值写入Text文件,并且它也与Swedish完美配合。 Oracle NLS Characterset设置为"AL32UTF8"。
我试过以下事情,但没有任何效果 -
1。将应用程序文化更改为"sv-SE"
2。添加了"IMEX = 1"到Excel扩展属性。
3。试图将Excel扩展属性字符集添加到UTF8,Unicode,ISO-8859-1等。
4。试图将变量String转换为UTF8,Unicode,ISO-8859-1
5。试图像这样添加Invariant Cultureinfo - Dim name As String = pr.ToString(CultureInfo.InvariantCulture)
6。试图将字符串添加到web.config连接字符串。
Any帮助将受到高度赞赏。
Hello,
I am using a Web Application to send data to Oracle 12C Databse reading from Excel file. Everything was working very fine until users try to upload excel with Swedish Characters like "Å,å,Ä,ä,Ö,ö". Application is reading Swedish Characters from Excel and storing on variables perfectly. But while checking Oracle side, I found, it is actually storing data with strange ASCII characters . I tried to show this value on a Gridview and it is showing Swedish characters perfectly. Also I tried to write the string value to Text file with StreamWriter and its also working perfectly with Swedish. Oracle NLS Characterset set to "AL32UTF8". I tried following things but nothing worked -
1. Changed application Culture to "sv-SE"
2. Added "IMEX=1" to Excel Extended properties.
3. Tried to add Excel Extended Properties character set to UTF8, Unicode, ISO-8859-1 etc.
4. Tried to convert variable String to UTF8, Unicode, ISO-8859-1
5. Tried to add Invariant Cultureinfo like this - Dim name As String = pr.ToString(CultureInfo.InvariantCulture)
6. Tried to add charactersets to web.config connection String.
Any help will be highly appreciated.
推荐答案
这篇关于在Oracle中发送瑞典语字符的问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!