CODEWITHSUNDEEP
c#datagridviewcharacter-encodingphpmyadmin
Zrinka
Zrinka

Reputation: 19

Characters not shown properly Visual Studio

I made a database in PhpMyAdmin and developed an application in Visual Studio 2010 C#.

When I add a new row in PhpMyAdmin, special characters are shown in Visual Studio properly, but when I add it in datagridview in Visual Studio, the characters č, ć and đ are not shown properly in tables.

Thank you in advance

Upvotes: 0

Views: 1839

Answers (2)

Zrinka
Zrinka

Reputation: 19

Solved problem: added to connectionString charset=utf8

connectionString="..... ;Default Command Timeout=300000; charset=utf8;"

That's it :)

Upvotes: 1

Dave
Dave

Reputation: 3621

It's likely that the collation on the database is set incorrectly as accent insensitive. This should help: Latin characters in phpMyAdmin with UTF-8 collation

Upvotes: 2

Related Questions