Read and write utf8 string in microsoft local database

Question

I am writing a WindowsForm application. I am using Visual Studio local database. Every thing is OK, but if I write some UTF8 content in forms, after saving and getting the content again it shows in this form "????". I think there is problem with database, but I don't know how to configure database to store utf8 content.

score 4 · Accepted Answer · answered May 16 '14 at 18:40

4

The field in the database needs to be an nvarchar instead of a varchar.

answered May 16 '14 at 18:40

RyanB

757
4
11

score 1 · Answer 2 · answered May 16 '14 at 18:46

1

Depending on how you save your information to database, if it is inline sql then prefix your content with N'yourvalue'.

answered May 16 '14 at 18:46

rfolt

111
5

Read and write utf8 string in microsoft local database

2 Answers2