Search code examples
c#mysqlvisual-studio-2012navicat

Can't save and display data correctly


When I'm trying to add data in database and fetch it in data-grid, all the Sindhi characters turn in "???????????" as shown in figure. i think its because of coding i.e Unicode, ASCII etc, i don't know what coding is compatible for Sindhi and how to use it. Kindly refer me material to understand and to solve this problem as I'm am newbie in C#.this problems i have shown in below picture, you can see record at id 5 is saved with question marks in navicat, same appears in the application when i upgrade or add things in Sindhi, kindly guide me


Solution

  • You need to change the characterset to utf8, for instructions on how to do that reffer to the answer to this question.

    Navicat utf8 not working on mysql database