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

[tixon <fre...@gm...>]

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
-- 
View this message in context: http://www.nabble.com/CHARACTER-SET-ISO8859_1-is-not-defined-tp16419444p16419444.html
Sent from the firebird-net-provider mailing list archive at Nabble.com.