Re: [Firebird-net-provider] CHARACTER SET ISO8859_1 is not defined

[VS-Polis <po...@vs...>]

Hi,
perhaps you could use the name that is contained in the 
Encoding.GetEncodings() method of the NET framework. So it has to be 
"iso-8859-1". That's only a presumption, not knowledge.
Juergen

tixon schrieb:
> hello everybody..
>
> I try to use Embedded Firebird with a DB create on CHARACTER SET ISO8859_1.
> The DB is open without problems via IBExpert, but my app canÂŽt do.
>
> I use c# VS2008, Firebird-2.0.3.12981, windows XP SP2, NET PROVIDER 
> FirebirdClient-2.1. In the app folder are icudt30.dll, icuin30.dll,
> icuuc30.dll, firebird.msg, fbembed.dll..
>
> If I try to open it  with 
>    fbcs.Charset = "ISO8859_1";  received the error:  CHARACTER SET ISO8859_1
> is not defined
>
> and in the other hands if i try to poen it with
>    fbcs.Charset = "NONE";  received the error: No message for error code
> 335544854 found
>
>
> The problem is I need the Charset = "ISO8859_1" course the data in the DB is
> in Spanish.
>
> Here is the code.
>
>
>             string apppath =
> System.IO.Path.GetDirectoryName(Application.ExecutablePath.ToString());
>
>             FbConnectionStringBuilder fbcs = new
> FbConnectionStringBuilder();
>             fbcs.ServerType = FbServerType.Embedded;
>             fbcs.Database = apppath + @"\" + "Data\\db.fdb";
>             fbcs.Charset = "ISO8859_1";
>             fbcs.ClientLibrary = apppath + @"\fbembed.dll";
>
>             FbConnection fb = new FbConnection(fbcs.ToString());
>
>             {
>                 try{
>                     fb.Open();
>                     DataTable dt = new DataTable();
>                     FbCommand fbc = new FbCommand("SELECT * FROM zonas",
> fb);
>                     FbDataAdapter fbda = new FbDataAdapter(fbc);
>                     fbda.Fill(dt);
>                     this.dataGrid1.DataSource = dt;
>                     fb.Close();
>
>                 }
>
>
> thanks
>
> tixon
>   

-- 

*_Juergen Thomas_*
Verlags-Software

Samlaendische Str. 3
13189 Berlin

Germany

http://www.vs-polis.de