Welcome to Dream.In.Code
Become an Expert!

Join 149,483 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 1,388 people online right now. Registration is fast and FREE... Join Now!




Problem inserting multilingual text into database from c# program

 
Reply to this topicStart new topic

Problem inserting multilingual text into database from c# program

salim2
5 May, 2007 - 05:24 PM
Post #1

New D.I.C Head
*

Joined: 5 May, 2007
Posts: 4


My Contributions
Hi,
my application is almost complete but i've run into a problem and it would be very much appreciated if someone could give me a solution for it.

I'm doing an asp.net web application using c# as the language for the code behind.
The problem is that when I insert a new row into the database from my application, multilingual text, like Japanese characters, is displayed as question marks like this ????.
However, when I insert something directly from the Administrator software, everything is displayed correctly.

the charset in the database is UTF-8 Unicode (utf8), and the collation is uftf8_general_ci which should technically display anykind of characters.

Thank you
User is offlineProfile CardPM
+Quote Post

salim2
RE: Problem Inserting Multilingual Text Into Database From C# Program
5 May, 2007 - 05:52 PM
Post #2

New D.I.C Head
*

Joined: 5 May, 2007
Posts: 4


My Contributions
I found it, i needed to add ;charset=utf8 to the connection string
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 1/7/09 04:37PM

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month