Using SMALLINT in table to store 'bool' value from C# works perfect with stand alone and embedded server. (May be I have a char set problem (none, ASCII, UTF8,...) in DB or connection when using CHAR(1) to store a 'bool'!) Thanks > > Thanks for the info > I will do some test with a SMALLINT field. > > > > > We are using SMALLINT type in our project. > > FB EF provider also generates tables with SMALLINT fields for code- > > first class fields. > > > > On 26 June 2015 at 14:49, Christian Waldmann <christian.waldmann@rte- > > ag.ch> wrote: > > > I am using Firebird 2.5.4, superServer and embedded, Visula Studio > > > 2013, .Net Framework 4.5.1, .Net Provider 4.6.2 > > > > > > > > > //==================================================================== > > > ====== > > > ================= > > > I have defined a table with "CyclePassed" CHAR(1) to store a > boolean > > > result > > > > > > CREATE TABLE "SampleSummaries" ( > > > "UniqueId" BIGINT DEFAULT 0 NOT NULL, > > > "EndTestRunId" BIGINT NOT NULL, > > > "Cycle" BIGINT NOT NULL, > > > "LoadPressure" FLOAT, > > > "LoadPressureMin" FLOAT, > > > "LoadPressureMax" FLOAT, > > > "ShutoffPressure" FLOAT, > > > "ShutoffPressureMin" FLOAT, > > > "ShutoffPressureMax" FLOAT, > > > "TravelTime" FLOAT, > > > "TravelTimeMin" FLOAT, > > > "TravelTimeMax" FLOAT, > > > "CyclePassed" CHAR(1) > > > ); > > > > > > > > > > > > //==================================================================== > > > ====== > > > ================= > > > // access to table from C# > > > > > > bool cyclePassed = true; > > > FbCommand command = new FbCommand(); > > > > > > command.CommandText = > > > "INSERT INTO \"SampleSummaries\" (" + > > > "\"EndTestRunId\", \"Cycle\", " + > > > "\"LoadPressure\", \"LoadPressureMin\", \"LoadPressureMax\", > " > > + > > > "\"ShutoffPressure\", \"ShutoffPressureMin\", > > > \"ShutoffPressureMax\", " + > > > "\"TravelTime\", \"TravelTimeMin\", \"TravelTimeMax\", > > > \"CyclePassed\"" + > > > ") VALUES (@EndTestRunId, @Cycle, " + > > > "@LoadPressure, @LoadPressureMin, @LoadPressureMax, " + > > > "@ShutoffPressure, @ShutoffPressureMin, @ShutoffPressureMax," > + > > > "@TravelTime, @TravelTimeMin, @TravelTimeMax, @CyclePassed > )"; > > > > > > command.Connection = samplesTableAdapter.Connection; > > > command.Transaction = transaction; > > > > > > command.Parameters.Add("@EndTestRunId", FbDbType.BigInt).Value = > > channelId; > > > ... > > > > > > // PROBLEM A: > > > > > > ====================================================================== > > > ====== > > > ============== > > > // works with stand alone server, > > > // but SQL error "string conversion error '49'" > > > // {Remark: 49 is the decimal ASCII code of '1'} > > > command.Parameters.Add("@CyclePassed", FbDbType.Boolean).Value = > > > cyclePassed ? '1' : '0'; > > > > > > // PROBLEM B: > > > > > > ====================================================================== > > > ====== > > > ============== > > > // works with embedded server, > > > // but "string truncation error" with stand alone server > > > command.Parameters.Add("@CyclePassed", FbDbType.Boolean).Value = > > > cyclePassed; > > > > > > // REMARK: > > > > > > ====================================================================== > > > ====== > > > ============== > > > // works with embedded server and standalone server Firebird 2.5.3, > > > with .Net Provider 2.0, .Net Framework 2.0, Visual Studio 2008 > > > command.Parameters.Add("@CyclePassed", FbDbType.Boolean).Value = > > > cyclePassed; > > > > > > // QUESTION > > > > > > ====================================================================== > > > ====== > > > ================ > > > Is this a bug or am I missing the correct usage of storing a > 'bool'? > > > > > > Happy coding > > > Christian Waldmann > > > > > > > ----------------------------------------------------------------------- > ------- > Monitor 25 network devices or servers for free with OpManager! > OpManager is web-based network management software that monitors > network devices and physical & virtual servers, alerts via email & sms > for fault. Monitor 25 devices for free with no restriction. Download > now http://ad.doubleclick.net/ddm/clk/292181274;119417398;o > _______________________________________________ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------------ Monitor 25 network devices or servers for free with OpManager! OpManager is web-based network management software that monitors network devices and physical & virtual servers, alerts via email & sms for fault. Monitor 25 devices for free with no restriction. Download now http://ad.doubleclick.net/ddm/clk/292181274;119417398;o _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider