Re: [Firebird-net-provider] UTF8 issue and Firebird Dot Net Data Provider

[Brad S. <swe...@YA...>]

Hello,

I have attached a zip file which contains a Delphi 6.0 project and a Visual Studio 2008 C# Dot Net 2.0 solution that can view the data and add a record to a the database.  The Delphi program uses FIBPlus components to connect to the database. There is also a Data folder which contains a subset (one table) of our original database and a Script folder which has a DDL for the attached database.  Both programs are setup to attach to the database in the data folder. I renamed the executables to _ex. Both programs are using a UTF8 connection.  The Delphi application displays the data correctly and Visual Studio does not.    

The current connection string without the user name and password we are using is:

DATABASE=C:\Infinity\Data\COLORNET.YDB;DATASOURCE=SWEARINB-PC;PORT=3050;DIALECT=3;CHARSET=UTF8;ROLE=;CONNECTION LIFETIME=0;CONNECTION TIMEOUT=15;POOLING=TRUE;PACKET SIZE=8192;SERVER TYPE=0

I used a FbConnectionStringBuilder in the attached solution but it does not have any affect.  


Thanks for your help,

Brad

-----Original Message-----
From: Michael Ludwig [mailto:mi...@gm...] 
Sent: Wednesday, January 18, 2012 12:20 PM
To: fir...@li...
Subject: Re: [Firebird-net-provider] UTF8 issue and Firebird Dot Net Data Provider

Brad Swearingen schrieb am 18.01.2012 um 13:51 (+0000):
> I have a database with a UTF8 connection where the data does not 
> appear in a UTF8 format.  I can save and look at the data using a 
> Delphi program connecting through the gds32.dll/fbClient.dll and it 
> works as expect.  If I use IBExpert, it also works correctly.  I 
> cannot get this to work with Visual Studio using the 
> FirebirdSql.Data.FirebirdClient.dll client.  Characters like È and è 
> appear like  .

What about posting your DDL and a minmal C#/VB.NET test case so others can have a look at what might be wrong?

Michael

> I have tried  version 2.6.5.0 and it works the same way as our 
> shipping version 2.5.2.0.  The Firebird version is 2.5.1. Is there a 
> known problem using UTF8 or is there anything I can try to get this to 
> work?

------------------------------------------------------------------------------
Keep Your Developer Skills Current with LearnDevNow!
The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________
Firebird-net-provider mailing list
Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider