This is documented, I think.
Based on 2.1 (bullet 5) of http://www.sqlite.org/datatype3.html the default
affinity is numeric. Since STRING is not understood, it has numeric
affinity.
-----Original Message-----
The actual table definition is :
CREATE TABLE T_VWG_ABFALLVERZEICHNIS (SCHLUESSEL String, BESCHREIBUNG
String, BEMERKUNG String, ID_GUID String, IST_PAUSCHALIERT String,
IST_KATEGORIE_ESK_BETRIEBSSTOF String);
SQLite version 3.7.16.2 2013-04-12 11:52:43
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select schluessel, typeof(schluessel)
...> from t_vwg_abfallverzeichnis
...> where id_guid in ('BEE7F6108F02416FA0C9D5DC777DB172',
'6061A3864C2546C4A7DDA9FDB321459F');
1|integer
01 01|text
sqlite>
I *expected* to gain TEXT affinity through the use of System.Data.SQLite and
it's strongly typed types (doppelt gemoppelt?), but apparently this is not
totally effective. Maybe Joe Mistachkin can say something about that?
Bernd
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
