Index: Doc/SQLite.NET.chm
==================================================================
--- Doc/SQLite.NET.chm
+++ Doc/SQLite.NET.chm
cannot compute difference between binary files

Index: SQLite.Designer/AssemblyInfo.cs
==================================================================
--- SQLite.Designer/AssemblyInfo.cs
+++ SQLite.Designer/AssemblyInfo.cs
@@ -30,10 +30,10 @@
 //      Build Number
 //      Revision
 //
 // You can specify all the values or you can default the Revision and Build Numbers 
 // by using the '*' as shown below:
-[assembly: AssemblyVersion("1.0.19.0")]
-[assembly: AssemblyFileVersion("1.0.19.0")]
+[assembly: AssemblyVersion("1.0.20.0")]
+[assembly: AssemblyFileVersion("1.0.20.0")]
 [assembly:AssemblyDelaySignAttribute(false)]
 [assembly:AssemblyKeyFileAttribute("..\\System.Data.SQLite\\System.Data.SQLite.snk")]
 [assembly:AssemblyKeyNameAttribute("")]

Index: SQLite.Interop/SQLite.Interop.rc
==================================================================
--- SQLite.Interop/SQLite.Interop.rc
+++ SQLite.Interop/SQLite.Interop.rc
@@ -51,11 +51,11 @@
 //
 // Version
 //
 
 VS_VERSION_INFO VERSIONINFO
- FILEVERSION 1,0,19,0
+ FILEVERSION 1,0,20,0
  PRODUCTVERSION 1,0,0,0
  FILEFLAGSMASK 0x17L
 #ifdef _DEBUG
  FILEFLAGS 0x1L
 #else
@@ -69,11 +69,11 @@
     BEGIN
         BLOCK "040904b0"
         BEGIN
             VALUE "Comments", "http://sourceforge.net/projects/sqlite-dotnet2"
             VALUE "FileDescription", "SQLite.NET Interop Library"
-            VALUE "FileVersion", "1.0.19"
+            VALUE "FileVersion", "1.0.20"
             VALUE "InternalName", "SQLite.Interop.DLL"
             VALUE "LegalCopyright", "Released to the public domain"
             VALUE "OriginalFilename", "SQLite3.DLL 3.2.7"
             VALUE "ProductName", "SQLite.NET"
             VALUE "ProductVersion", "1.0"

Index: System.Data.SQLite/AssemblyInfo.cs
==================================================================
--- System.Data.SQLite/AssemblyInfo.cs
+++ System.Data.SQLite/AssemblyInfo.cs
@@ -37,9 +37,9 @@
 //      Build Number
 //      Revision
 //
 // You can specify all the values or you can default the Revision and Build Numbers 
 // by using the '*' as shown below:
-[assembly: AssemblyVersion("1.0.19.0")]
+[assembly: AssemblyVersion("1.0.20.0")]
 #if !PLATFORM_COMPACTFRAMEWORK
-[assembly: AssemblyFileVersion("1.0.19.0")]
+[assembly: AssemblyFileVersion("1.0.20.0")]
 #endif

Index: System.Data.SQLite/SQLiteBase.cs
==================================================================
--- System.Data.SQLite/SQLiteBase.cs
+++ System.Data.SQLite/SQLiteBase.cs
@@ -147,20 +147,26 @@
       if (typ.Affinity == 0) typ = SQLiteConvert.ColumnToType(stmt, index);
       if (IsNull(stmt, index)) return DBNull.Value;
       
       Type t = SQLiteConvert.SQLiteTypeToType(typ);
 
-      if (t == typeof(byte[]))
+      switch (TypeToAffinity(t))
       {
-        int n = (int)GetBytes(stmt, index, 0, null, 0, 0);
-        byte[] b = new byte[n];
-        GetBytes(stmt, index, 0, b, 0, n);
-
-        return b;
+        case TypeAffinity.Blob:
+          int n = (int)GetBytes(stmt, index, 0, null, 0, 0);
+          byte[] b = new byte[n];
+          GetBytes(stmt, index, 0, b, 0, n);
+          return b;
+        case TypeAffinity.DateTime:
+          return GetDateTime(stmt, index);
+        case TypeAffinity.Double:
+          return Convert.ChangeType(GetDouble(stmt, index), t, null);
+        case TypeAffinity.Int64:
+          return Convert.ChangeType(GetInt64(stmt, index), t, null);
+        default:
+          return GetText(stmt, index);
       }
-
-      return Convert.ChangeType(GetText(stmt, index), t, null);
     }
 
     internal abstract int  CreateCollation(string strCollation, SQLiteCollation func);
     internal abstract int  CreateFunction(string strFunction, int nArgs, SQLiteCallback func, SQLiteCallback funcstep, SQLiteCallback funcfinal);
     internal abstract void FreeFunction(int nCookie);

Index: bin/Designer/Install.vbs
==================================================================
--- bin/Designer/Install.vbs
+++ bin/Designer/Install.vbs
@@ -1,6 +1,6 @@
-Const SQLiteVersion = "1.0.19.0"
+Const SQLiteVersion = "1.0.20.0"
 
 Main
 
 Sub Main()
 

Index: bin/Designer/SQLite.Designer.dll
==================================================================
--- bin/Designer/SQLite.Designer.dll
+++ bin/Designer/SQLite.Designer.dll
cannot compute difference between binary files

Index: bin/itanium/System.Data.SQLite.DLL
==================================================================
--- bin/itanium/System.Data.SQLite.DLL
+++ bin/itanium/System.Data.SQLite.DLL
cannot compute difference between binary files

Index: bin/x64/System.Data.SQLite.DLL
==================================================================
--- bin/x64/System.Data.SQLite.DLL
+++ bin/x64/System.Data.SQLite.DLL
cannot compute difference between binary files