Re: [Firebird-net-provider] Charset problems

[Luca]

Mercea Paul ha scritto:
> 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;
>   
In my app, the connection string is stored in the Settings.settings file
of the project inside the solution. (I don't know if it's a good choice
but it is the default position in VS2008). This is how it sounds:
<Setting Name="FbConnectionString" Type="(Connection string)"
Scope="Application">
      <DesignTimeValue Profile="(Default)">&lt;?xml version="1.0"
encoding="utf-16"?&gt;
&lt;SerializableConnectionString
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
xmlns:xsd="http://www.w3.org/2001/XMLSchema"&gt;
  &lt;ConnectionString&gt;character set=ASCII;data source=DELTA3;user
id=SYSDBA;password=masterke;initial
catalog=C:\Programmi\Firebird\GESTIXDB2&lt;/ConnectionString&gt;
  &lt;ProviderName&gt;FirebirdSql.Data.FirebirdClient&lt;/ProviderName&gt;
&lt;/SerializableConnectionString&gt;</DesignTimeValue>
      <Value Profile="(Default)">character set=ASCII;data
source=DELTA3;user id=SYSDBA;password=masterke;initial
catalog=C:\Programmi\Firebird\GESTIXDB2</Value>
    </Setting>

As you can see the character set is correctly ASCII, as in FlameRobin. I
think everything is correct here.

> 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';
>   
Every reading of a blob field, every reading of a VARCHAR field.... it's
a bit too complicated to change all the data request with COLLATE.
I don' t think this is a good solution. Thanks indeed.

Any other approach ?


------------------------------------------------------------------------------
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
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider