On 15 Jul 2013, at 9:18pm, Bernd <be...@web.de> wrote:
> 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?
The following two statements do different things.
INSERT INTO myTable VALUES (01)
INSERT INTO myTable VALUES ('01')
Can you tell what's being done in your setup ? Is there a way using your API
that you can stress that the value you're binding or inserting is text, not a
number ?
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
