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
|
