CODEWITHSUNDEEP
encodingado.netcharacter-encodingfirebirddataprovider
Alex M
Alex M

Reputation: 1304

How to obtain data using Firebird ADO.NET Data Provider

I have a question regarding obtain data using Firebird ADO.NET Data Provider. I can get data from DB w/o any problems but it seems that I use wrong char-set or encoding and I receive next: http://my.jetscreenshot.com/2554/20110717-qllq-27kb.jpg (the value of fields from DB are located in red squares).

Does anybody have any ideas how I can get data in correct way?

Thanks in advance!

Upvotes: 0

Views: 1605

Answers (1)

IamDeveloper
IamDeveloper

Reputation: 5226

I'm not sure if it's still relevant, but maybe it will help someone else.

Try to set charset in web.config/app.config like this:

 <add name="MyConnectionString" connectionString="Server=127.0.0.1; 
  User=SYSDBA; Password=masterkey; Database=db.gdb; Charset=win1250;"
  providerName="FirebirdSql.Data.FirebirdClient" />

The values of the charset could also be win1250, iso859_1, iso859_2 etc. as stated here or here.

Upvotes: 1

Related Questions