[sqlite] System.Data.SQLite: Leading zeros being stripped off

[Bernd]

I know that SQLite is inherently type-less, but I'm using 
System.Data.SQLite which tries it very best to force that into the 
common ADO.NET schema.
I'm having troubles with some text that has leading zeros, like '01', 
'02' and so on. 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 - via a parameterized insert query and a parameter 
DbType of 'String' as well. Nonetheless the leading zero gets stripped 
off the text. Any ideas how I could preserve those leading zeros?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users