UnQLite Users Forum

Problem to store accented characters in database

append delete PapyRef

Hi,

First of all thanks for the awesome project. I use Unqlite library in C# with System.Data.Unqlite. I have problem to store accented characters in database.

C# example code to store accented characters in database
UnqliteDB unqliteDBCrawledPage = UnqliteDB.Create();
unqliteDBCrawledPage.Open("TestDB.uql", Unqlite_Open.CREATE);
unqliteDBCrawlPage.SaveKeyValue(crawledPage.Uri.AbsoluteUri, "Test accented characters : éè");
unqliteDBCrawlPage.Close();

---

C# example code to retrieve accented characters from database
UnqliteDB unqliteDBCrawledPage = UnqliteDB.Create();
unqliteDBCrawledPage.Open("TestDB.uql", Unqlite_Open.READONLY);
using (KeyValueCursor cursor = unqliteDBCrawledPage.CreateKeyValueCursor())
{
while (cursor.Read()) { string test = cursor.GetValue(); }
}
unqliteDBCrawledPage.Close();

I got "Test accented characters : ????" in 'test' variable

Reply RSS

Replies

append delete #1. chm

Hi,

UnQLite, here I mean the C library does not not have problem with whatever values you're planning to store within (Unicode, ANSI or binary data). You've to check that with the binding developer, you can open a ticket in their github page and see with them.

https://github.com/majimenezp/System.Data.Unqlite

Hope this helps

Reply

(Leave this as-is, it’s a trap!)

There is no need to “register”, just enter the same name + password of your choice every time.

Pro tip: Use markup to add links, quotes and more.

Your friendly neighbourhood moderators: chm_at_symisc, devel_at_symisc