Am 15.07.2013 22:30, schrieb Gerry Snyder:
On 7/15/2013 1:18 PM, Bernd wrote:
.... I'm reading that text out of an Oracle-DB into a SQLite table
which has the affected column defined as 'String' - which maps to TEXT
in native SQLite
No. Look at section 2.1 of http://sqlite.org/datatype3.html Only CHAR,
CLOB, or TEXT cause the column to have TEXT affinity.
HTH,
Gerry Snyder
If I understand correctly, this is right for the C API or rather SQL
queries without any interpreting layer in between, but the .NET wrapper
explicitly maps type String to affinity TEXT in SQLiteConvert.cs.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
