DataType Mapping text, tinytext, mediumtext, longtext

DataType Mapping text, tinytext, mediumtext, longtext

Postby Bitpainter » Thu 09 Feb 2017 15:30

Hello,

i use a DataGridView with an bound DataTable as DataSource.

Below there is the method to fill the DataTable:
Code: Select all
Using myCommand As New Devart.Data.MySql.MySqlCommand(myQuery, myConnection)
            myDataAdapter = New Devart.Data.MySql.MySqlDataAdapter(myCommand)
            myDataTable = oDataSet.Tables.Add
            myDataAdapter.Fill(myDataTable)
End Using


The problem now is that the .net DataType for MySQL *text is system.byte[] in DataTable
Why the Data for *text columns is not a string?

In the EF Documentation it is declared as string, why not in a DataTable?
https://www.devart.com/dotconnect/mysql/docs/DataTypeMapping.html

I don't want do Clone the DataTable and change the DataType for the Columns.
Is there a way to say the MySql Provider to map MySql *text DataTypes to String.

Best Regards
Bitpainter
 
Posts: 1
Joined: Thu 09 Feb 2017 15:13

Re: DataType Mapping text, tinytext, mediumtext, longtext

Postby Pinturiccio » Mon 13 Feb 2017 11:38

We could not reproduce the issue. Please create and send us a small test project with corresponding DDL\DML scripts which reproduces the issue. Please also tell us the version of dotConnect for MySQL and the MySQL server.
Pinturiccio
Devart Team
 
Posts: 1953
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for MySQL