Sql Server Compact string encoding

Question

How to extort using utf8 for strings in SqlServer CE?

To save 'ą', 'ę' etc. language special characters?

@Edit:

I use EntityFramework and when db is mysqlserver data have special characters like 'ą', 'ę' but when I swtich to SqlServerCompact the data lost special chars.

Marc Gravell · Accepted Answer · 2017-06-13 12:41:06Z

1

SQL Server CE supports nvarchar and ntext, which are UTF-16. Basically: store your data as UTF-16 in an nvarchar column, and you'll be set. Conveniently, .NET is also mostly UTF-16 (the char and string types are implemented as UTF-16), so this works out just fine.

If you absolutely must use UTF-8, you'll have to use varbinary / image, which means you lose most of the useful features of a database. You'll be able to store and retrieve, but filtering and other operations are much harder.

When storing data, make sure you either use N'foo' syntax for literals, or ADO.NET parameters of DbType.String (nvarchar) / DbType.StringFixedLength (nchar), and not DbType.AnsiString (varchar) / DbType.AnsiStringFixedLength (char)

edited Jun 13, 2017 at 12:41

answered Jun 13, 2017 at 12:36

Marc Gravell

1.1m273 gold badges2.6k silver badges3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Sql Server Compact string encoding

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related