Hi,
I found that the ado.net provider for sqlite support some types that do
not really match the substrings here
http://sqlite.phxsoftware.com/forums/t/31.aspx
any idea?
COUNTER DbType.Int64 AUTOINCREMENT DbType.Int64 IDENTITY DbType.Int64 LONG
DbType.Int64 TINYINT DbType.Byte INTEGER DbType.Int64 INT DbType.Int32
VARCHAR DbType.String NVARCHAR DbType.String CHAR DbType.String NCHAR
DbType.String TEXT DbType.String NTEXT DbType.String STRING DbType.String
DOUBLE DbType.Double FLOAT DbType.Double REAL DbType.Single BIT
DbType.Boolean YESNO DbType.Boolean LOGICAL DbType.Boolean BOOL
DbType.Boolean NUMERIC DbType.Decimal DECIMAL DbType.Decimal MONEY
DbType.Decimal CURRENCY DbType.Decimal TIME DbType.DateTime DATE
DbType.DateTime TIMESTAMP DbType.DateTime DATETIME DbType.DateTime BLOB
DbType.Binary BINARY DbType.Binary VARBINARY DbType.Binary IMAGE
DbType.Binary GENERAL DbType.Binary OLEOBJECT DbType.Binary GUID DbType.Guid
UNIQUEIDENTIFIER DbType.Guid MEMO DbType.String NOTE DbType.String LONGTEXT
DbType.String LONGCHAR DbType.String SMALLINT DbType.Int16 BIGINT
DbType.Int64 LONGVARCHAR DbType.String SMALLDATE DbType.DateTime
SMALLDATETIME DbType.DateTime
2008/11/4, Kees Nuyt <[EMAIL PROTECTED]>:
>
> On Tue, 4 Nov 2008 10:24:18 +0800, <[EMAIL PROTECTED]>
> wrote :
>
> >Hi,
> >
> >I found an offical mention here: http://www.sqlite.org/datatype3.html
>
> It is all on that page. Datatypes are dynamic. In general,
> the value inserted determines the type, not the column
> definition.
>
> >but seems not a "full list", because it only mention some "Affinity".
>
> http://www.sqlite.org/datatype3.html#affinity is very
> important.
>
> >I want a full list of ALL VALID data types that sqlite
> >really support, here is my result, does anyone could make
> >it really full list?
> >
> >REAL
> >FLOA (FLOAT will do??)
> >DOUB (DOUBLE will do??)
> >INT (duplicate with INTEGER??)
> >INTEGER
> >NUMERIC
> >DATETIME
> >CHAR
> >CLOB
> >VARCHAR (NVARCHAR will do??)
> >TEXT (NTEXTwill do??)
> >BLOB
>
> NONE might be another one.
> You can use _anything_ here, even something like MYTYPE or
> BLAHBLAH, but the declared type is only recognised if one of
> the substrings above are matched. If there is no match,
> numeric affinity will be used, but if you insert a text
> string, it will still be stored as text.
>
> NVARCHAR contains CHAR so its affinity will be TEXT.
>
> > and, does CHAR/CLOB/VARCHAR/TEXT/BLOB all support
> > size definition? let's say CHAR(50), VARCHAR(100),
> > TEXT(200), BLOB(500) etc?
>
> Yes, syntactically they do, but the size definition is
> simply ignored.
>
> If you want strict typing, you will have to add that layer
> in your application or enforce it using CONSTRAINTs and
> TRIGGERs.
> --
> ( Kees Nuyt
> )
> c[_]
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
Regards,
灵感之源
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
