나이스곰 블로그

SQLite DB에다가 Adapter를 사용하여 DataTable을 Update 하려고 하니 DbType과 일치하는 실제 DB의 column type이 명확하지 않아  찾아보았더니 관련내용이 정리된 문서가 있어 공유합니다.

Since the SQLite engine is inherently typeless and ADO.NET is much more strongly typed, the ADO.NET wrapper must make certain decisions about the columns returned in any given SQL query.  One of the deciding factors is the underlying datatype declared in the CREATE TABLE statement.

The following lists the datatypes and mappings the SQLite ADO.NET wrapper understands.  If there is anything missing, wrong, or needs adding, please let me know:

DateTime's are stored in one of two formats.  The default datetime format is ISO8601, and you specify the format in the connection string like Finisar does.  The varying ISO8601 strings that this class uses to convert are:

"yyyy-MM-dd HH:mm:ss"

The other format is Ticks.  In the SQLiteConnection class in the helpfile is a description of all the connectionstring options.

,
"yyyyMMddHHmmss",
"yyyyMMddTHHmmssfffffff",
"yyyy-MM-dd",
"yy-MM-dd",
"yyyyMMdd",
"HH:mm:ss",
"THHmmss"

출처 : http://www.blogbus.com/hyangl-logs/2219450.html

상업음악들을 제작하는 Immediate Music 社 의 음악 중 하나입니다.

박력있고 깔끔하네요^^