来自ASP.Net的MySql中的UTF-8字符插入问题 [英] UTF-8 Chars insertion problem in MySql from ASP.Net front

问题描述

我想从ASP.Net的前端在MySql数据库中输入一些UTF-8字符串.

我只是将发现的内容从google.com/transliterate((印地语)印地语版本)复制粘贴到文本框中，当我尝试将文本框的UTF插入Mysql时，它会显示????在Mysql数据库中.我尝试在VS 2005中调试代码，并将插入字符串从vs2005复制到mysql.它再次显示了我吗???数据库中的字符串(但是准备的字符串正确显示了UTF字符，如下所示:

插入新闻(NewsTitle，NewsDetails，NewsFooter)值(``उदाहरण''，``उदाहरण''，``उदाहरण'')

由后面的代码生成:

插入新闻(NewsTitle，NewsDetails，NewsFooter)值(" + t1.Text.ToString()+''，''" + t2.Text.ToString()+''，''" + t3 .Text.ToString()+'')";

但是当我在mysql中使用此字符串时，它显示????

奇怪的是，当我在MySql查询浏览器中键入相同的字符串并仅显式粘贴utf字符时，它工作正常并显示UTF字符.

:confused:

有人可以让我知道什么是Asp.net字符串生成错误.

提前致谢.

Jay Khatri

Hi,

I Would like to enter few UTF-8 Strings in MySql Database from ASP.Net front.

I just copy paste the findings from google.com/transliterate ((indic) Hindi version) to the textboxes and when I try to insert the textbox''s UTF to Mysql it shows ???? in the Mysql Database. I tried debugging the code in VS 2005 and copied the insert string from the vs2005 to mysql. It again shown me ???? in the database (prepared string however was showing UTF Chars properly like this:

insert into news (NewsTitle,NewsDetails,NewsFooter) values (''उदाहरण'',''उदाहरण'',''उदाहरण'')

generated by code behind:

"insert into news (NewsTitle,NewsDetails,NewsFooter) values (''" + t1.Text.ToString() + "'',''" + t2.Text.ToString() + "'',''" + t3.Text.ToString() + "'')";

but when I use this string in mysql it shows ????

Strange is when I type the same string in MySql query browser and paste only the utf chars उदाहरण explicitly, It works fine and show the UTF chars.

:confused:

Can someone let me know what Asp.net string is generating wrong.

Thanks in advance.

Jay Khatri

推荐答案

我得到了答案，

只需编辑连接字符串并放置Character Set = utf8;

就是这样.

最好的问候

杰伊·哈特里(Jay Khatri)

I got the answer,

Just edit the connectionstring and place Character Set=utf8;

Thats it.

Best Regards

Jay Khatri

这篇关于来自ASP.Net的MySql中的UTF-8字符插入问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！