Can't save and display data correctly

Question

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

In both, database and your script – pavel Feb 21 '15 at 09:29 — pavel, Feb 21 '15 at 09:29

score 0 · Accepted Answer · edited May 23 '17 at 10:24

0

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

edited May 23 '17 at 10:24

Community

1
1

answered Feb 21 '15 at 09:26

Omer Farooq

3,754
6
31
60

score 0 · Answer 2 · answered Feb 21 '15 at 09:33

0

Set Your DataType as Nvarchar(1000) in C# as well as mysql

answered Feb 21 '15 at 09:33

Dgan

10,077
1
29
51

score 0 · Answer 3 · answered Feb 21 '15 at 10:13

0

I solved my problem by

going in navicat
open table in design view
in tabs there is Options tab inside options tab I changed character set and collation to UTF8

answered Feb 21 '15 at 10:13

sam

29
5

and also set utf encoding in coing where you provide path for sql – sam Feb 22 '15 at 03:40

Can't save and display data correctly

3 Answers3