Devart Forums

I have a database with encoding latin1 and the client_encoding=latin1.
I can insert data to the database directly without problems but I can't do it from my .NET application using dotConnect for PostgreSQL. I must insert special characters like ñ or accented vowels (á, é, etc).
I read that I should set the unicode property to true in the object PgSqlConnection but do not know how I can do it because I am using an ObjectContext object of ADO.NET 3.5
Help me please

When you are generating Devart Entity Model, the connection string used by your ObjectContext is stored at the *.config file of your application. Please add the Unicode=true; parameter to your connection string and notify us about the results.

connectionstring="...unicode=true". Now the error always is "invalid byte sequence for encodign "UTF8". Database encoding = latin1. client_encoding=latin1 in postgres.conf. Help me please

Problem resolved. I put rtf content in a RichTextBox and after save this content from the .rtf property of the richtextbox object to the database.
Thank you for help.