1 Replies - 3324 Views - Last Post: 05 May 2007 - 06:52 PM Rate Topic: -----

#1 salim2  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 05-May 07

Problem inserting multilingual text into database from c# program

Posted 05 May 2007 - 06:24 PM

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

Is This A Good Question/Topic? 0
  • +

Replies To: Problem inserting multilingual text into database from c# program

#2 salim2  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 4
  • Joined: 05-May 07

Re: Problem inserting multilingual text into database from c# program

Posted 05 May 2007 - 06:52 PM

I found it, i needed to add ;charset=utf8 to the connection string
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1