[RESOLVED] CF 3.5 - SQLCe - Impossible to insert éèà... (UTF8 chars)

[FrenchFry]

Hi,

I notice in my database that specials letters (é,è,à,ç,ê,î,ô,û) are not inserted
For example if I write "café" : I have "caf㠦". My column datatype is nvarchar, is it normal ?

I have some other questions :

[RESOLVED] I want to insert some datas so I use to write something like this example, but how can I insert a ' when delimiters are ' ?

ExecuteSQL("INSERT INTO MyTable VALUES ('MyGameIs', 'Le Jeu de l'Oie')")

In VB.NET, we just have to insert a second time the letter. How to: Put Quotation Marks in a String (Windows Forms)

And how to make a multiple insert in 1 SQL ?

VALUES (1, 'Name1'), (2, 'Name2'), (3, 'Name3')

And my last question, not about SQL, but when I have to do .Dispose() method ?
Because sometimes when I open a form, or create variables, I do : myVar = New Something

But I never do .Dispose() at the end, should I ?

[RESOLVED] I don't know if it's because of that, but I have to wait 10 min to build my project before to simulate it.
It takes so much long time (I install a patch, but I feel that's change nothing) and it's a bit boring to wait without to do nothing. (Imagine when you forget a little ' or ), and when you have to wait 10 min more! )
I change one thing to the recommandation (!= true, by == true) and it works now. How to reduce build time in VS 2008

Thank you!