Hi
I think you could use 2 solution:
1. you could add charset to your connection string:
FbConnectionStringBuilder fbcs = new FbConnectionStringBuilder();
fbcs.Database = @"C:\Data\myDb.fdb";
fbcs.Charset = "NONE"; <- put your charset...
.....
fbcs.Dialect = 3;
2. you can use collate for that field:
SELECT * FROM T1 WHERE UPPER(COL1 COLLATE PXW_CYRL) = 'ÔÛÂÀ'
select blob_column from table
where blob_column collate unicode = 'foo';
HTH,
Paul
> -----Original Message-----
> From: Barbiturico76 [mailto:[email protected]]
> Sent: Wednesday, March 11, 2009 05:13
> To: For users and developers of the Firebird .NET providers
> Subject: [Firebird-net-provider] Charset problems
>
> Dear Firebird gurus,
> I need your help!
> I'm a C# developer and I'm experencing some troubles when retrieving
> data from a Firebird 2.0 server.
>
> When I get data (text) from VarChar fields or Blob type 0 fields, I
> always receive the char '?' instead of 'à', 'é', 'ì', 'ò' or 'ù' and I
> really cannot understand why.
> The data are correctly stored in the DB because when I use FlameRobin
> 0.8.6 to read data, those strings are read correctly.
>
> I use the Firebird .NET Data Provider Version 2.1.0 for .NET 2.0 inside
> Visual Studio 2008 good installed and working.
>
> Maybe it is a problem of character encoding... I tried to understand
> this aspect but made no step ahead.
> What I know is that the original DB has ASCII charset (FlameRobin
> rules!), and in the connection string inside VB2008 the charset called
> is ASCII too.
>
> Could you please give me a tip to solve my problem?
> Or redirect me to someone knowing how...
>
> Thx in advance.
> Luca D
> Italy
>
>
> -----------------------------------------------------------------------
> -------
> Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
> powering Web 2.0 with engaging, cross-platform capabilities. Quickly
> and
> easily build your RIAs with Flex Builder, the Eclipse(TM)based
> development
> software that enables intelligent coding and step-through debugging.
> Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
> _______________________________________________
> Firebird-net-provider mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
