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.
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
