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

On 16.07.2013 13:26, Bernd Lehmkuhl wrote: On 16 Jul 2013, at 4:39am, Bernd Lehmkuhl wrote: Am 15.07.2013 22:26, schrieb Simon Slavin: The following two statements do different things. INSERT INTO myTable VALUES (01) INSERT INTO myTable VALUES ('01') Can you tell what's being

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

Bernd Lehmkuhl wrote: > > 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

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

On 16 Jul 2013, at 12:26pm, Bernd Lehmkuhl wrote: > 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);

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

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

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

> On 16 Jul 2013, at 4:39am, Bernd Lehmkuhl wrote: > >> Am 15.07.2013 22:26, schrieb Simon Slavin: >>> >>> 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

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

On 16 Jul 2013, at 4:39am, Bernd Lehmkuhl wrote: > Am 15.07.2013 22:26, schrieb Simon Slavin: >> >> 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 ?

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

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

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

Am 15.07.2013 22:26, schrieb Simon Slavin: On 15 Jul 2013, at 9:18pm, Bernd 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

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

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

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

On 15 Jul 2013, at 9:18pm, Bernd 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

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

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