firebird-net-provider

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

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

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 �.  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?



Thanks,

Brad

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

[Michael L. <mi...@gm...>]

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?

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

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

[Alexander M. <amu...@ho...>]

I don’t have this problem.  Is your connectionstring correct?  Use FbConnectionstringBuilder and make sure you set it to utf8?  
 
Good luck
 
Alexander
 
Van: Brad Swearingen [mailto:swe...@YA...] 
Verzonden: woensdag 18 januari 2012 14:52
Aan: fir...@li...
Onderwerp: [Firebird-net-provider] UTF8 issue and Firebird Dot Net Data Provider
 
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 �.  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?
 
 
 
Thanks,
 
Brad
 
 

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

[Scott P. <sco...@vi...>]

Hi Brad,


I've had that before where the Character Set specified in the Connection 
String is different to that the database was connected with, or some 
combination there of with differences in the connections.  Often with 
other symbol characters like:

£
`
'

You might want to just check the connection settings from the 
applications that do work currently, and then compare accordingly to 
ensure the connections are identically configured first.

If that is still an issue afterwards, then please do mention here again.


Kind regards,


Scott :)


On 18/01/2012 13:51, Brad Swearingen wrote:
>
> 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 ?. 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?
>
> Thanks,
>
> Brad
>
>
>
> ------------------------------------------------------------------------------
> 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