[Firebird-net-provider] Error on simple select varchar column in firebird provider for compact framework

[Mutz <mu...@si...>]

Hello,

 

I created a simple apllication for Windows Mobile for return any
informations of the simple select command.

The connection to the Firebird server is perfect.

 

Let's consider this simple table

 

CREATE TABLE ENTIDADES (

       COD_ENTIDADE integer NOT NULL,

       DT_DATE date,

       ST_EMAIL varchar(30),

       CONSTRAINT PK_ENTIDADES PRIMARY KEY (COD_ENTIDADE));

 

INSERT INTO ENTIDADES (COD_ENTIDADE, ST_EMAIL) VALUES (1, '01.01.2009',
'te...@te...');

INSERT INTO ENTIDADES (COD_ENTIDADE, ST_EMAIL) VALUES (2, '01.01.2009' ,
'ro...@ro...');

 

To create a select command with a integer or date column, its works
perfectly as the code below.

 

            FbDataAdapter da = new FbDataAdapter("select cod_entidade,
dt_cadastro from entidades", cn);

 

            DataTable dtEntidades = new DataTable();

 

            da.Fill(dtEntidades);

 

But to the same command using a varchar column as below, I get the following
error in Fill() command.

I noticed that this error occurs only when using a column of type char or
varchar in select command.

 

            FbDataAdapter da = new FbDataAdapter("select st_email from
entidades", cn);

 

            System.PlatformNotSupportedException was unhandled

              Message="PlatformNotSupportedException"

              StackTrace:

                   at System.Text.Encoding.GetDataItem()

                   at System.Text.CodePageEncoding..ctor(Int32 codepage)

                   at System.Text.Encoding.GetEncoding(Int32 codepage)

                   at System.Text.Encoding.GetEncoding(String name)

                   at FirebirdSql.Data.Common.Charset.GetEncoding()

                   at FirebirdSql.Data.Common.Charset.GetString(Byte[]
buffer, Int32 index, Int32 count)

                   at
FirebirdSql.Data.Client.Managed.Version10.XdrStream.ReadString(Charset
charset, Int32 length)

                   at
FirebirdSql.Data.Client.Managed.Version10.XdrStream.ReadString(Charset
charset)

                   at
FirebirdSql.Data.Client.Managed.Version10.XdrStream.ReadValue(DbField field)

                   at
FirebirdSql.Data.Client.Managed.Version10.GdsDatabase.ReadValue(DbField
field)

                   at
FirebirdSql.Data.Client.Managed.Version10.GdsStatement.ReadDataRow()

                   at
FirebirdSql.Data.Client.Managed.Version10.GdsStatement.Fetch()

                   at FirebirdSql.Data.FirebirdClient.FbCommand.Fetch()

                   at FirebirdSql.Data.FirebirdClient.FbDataReader.Read()

                   at System.Data.ProviderBase.DataReaderContainer.Read()

                   at
System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)

                   at System.Data.Common.DataAdapter.FillFromReader(DataSet
dataset, DataTable datatable, String srcTable, DataReaderContainer
dataReader, Int32 startRecord, Int32 maxRecords, DataColumn
parentChapterColumn, Object parentChapterValue)

                   at System.Data.Common.DataAdapter.Fill(DataTable[]
dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)

                   at System.Data.Common.DbDataAdapter.FillInternal(DataSet
dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior)

                   at System.Data.Common.DbDataAdapter.Fill(DataTable[]
dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command,
CommandBehavior behavior)

                   at System.Data.Common.DbDataAdapter.Fill(DataTable
dataTable)

                   at RofranColetor.fmEntradaEstoque.BuscaMateriais()

                   at RofranColetor.fmEntradaEstoque.button1_Click(Object
sender, EventArgs e)

                   at System.Windows.Forms.Control.OnClick(EventArgs e)

                   at System.Windows.Forms.Button.OnClick(EventArgs e)

                   at System.Windows.Forms.ButtonBase.WnProc(WM wm, Int32
wParam, Int32 lParam)

                   at System.Windows.Forms.Control._InternalWnProc(WM wm,
Int32 wParam, Int32 lParam)

                   at Microsoft.AGL.Forms.EVL.EnterModalDialog(IntPtr
hwnModal)

                   at System.Windows.Forms.Form.ShowDialog()

                   at RofranColetor.fmMain.listView1_ItemActivate(Object
sender, EventArgs e)

                   at System.Windows.Forms.ListView.OnItemActivate(EventArgs
e)

                   at System.Windows.Forms.ListView.HandleItemActivate(Int32
iItem)

                   at System.Windows.Forms.ListView.WnProc(WM wm, Int32
wParam, Int32 lParam)

                   at System.Windows.Forms.Control._InternalWnProc(WM wm,
Int32 wParam, Int32 lParam)

                   at Microsoft.AGL.Forms.EVL.EnterMainLoop(IntPtr hwnMain)

                   at System.Windows.Forms.Application.Run(Form fm)

                   at RofranColetor.Program.Main()

 

This is a bug or a wrong procedure?

 

Regards