Considering the following table definition:
*/create table TESTTABLE (
DATA blob not null
)/*
And this example code:
*/// run query: "select * from TESTTABLE"
using (DbDataReader dataReader = command.ExecuteReader())
{
string typeName = reader.GetDataTypeName(0);
}/*
In Mono for Android version 4.0.6 the variable typeName would contain the
value “blob”.
However, in version 4.2.1 we get “System.Byte[]”. We need the native SQLite
data type (as defined in the CREATE TABLE statement).
DbDataReader.GetDataTypeName() should return the native SQL data type, as it
does, for example with a MS SQL Server SqlDataReader. Here GetDataTypeName()
returns for example “varchar” and not “String”.
--
View this message in context:
http://mono-for-android.1047100.n5.nabble.com/SqliteDataReader-GetDataTypeName-returns-Net-data-type-instead-of-native-SQLite-data-type-in-4-2-1-tp5709933.html
Sent from the Mono for Android mailing list archive at Nabble.com.
_______________________________________________
Monodroid mailing list
[email protected]
UNSUBSCRIBE INFORMATION:
http://lists.ximian.com/mailman/listinfo/monodroid
