// GPSのログの行を手動変更した場合のchecksumの再計算など
function GPS_NMEA_Line_Checksum(s : string) : integer;
  var
   i , sum : integer;
begin
  // $data*<CR><LF>
  // $と*の間の文字をxorします
  // Todo : 1文字目が $以外は例外生成
  sum := 0;
  s := Trim(s);
  for i := 1 to Length(s) do
   begin
     if (i = 1) and (s[1] = ''$'') then continue;
     if (s[i] = ''*'') then break;
      sum := sum xor  Byte(s[i]);
   end;
   Result := sum;
end;

procedure TForm1.Button_RecalcClick(Sender: TObject);
begin
  Edit2.text := Format(''%.2x'' , [ GPS_NMEA_Line_Checksum(Edit1.text)]);
end;

procedure TForm1.Button_ClearClick(Sender: TObject);
begin
  Edit1.text := '''';
end;

--- SQLite-47fee16ba9bd8ab2/VERSION	2007-01-09 01:20:28.000000000 +0900
+++ SQLite-47fee16ba9bd8ab2/VERSION	2011-12-09 21:58:33.703125000 +0900
@@ -1 +1 @@
-2.8.17
+2.8.17-p2
--- SQLite-47fee16ba9bd8ab2/src/shell.c	2007-01-09 01:20:28.000000000 +0900
+++ SQLite-47fee16ba9bd8ab2/src/shell.c	2011-12-10 10:50:15.031250000 +0900
@@ -82,6 +82,8 @@
 */
 extern int sqliteIsNumber(const char*);
 
+static int dump_mode = 3; // dump of sqlite version
+
 /*
 ** This routine reads a line of text from standard input, stores
 ** the text in memory obtained from malloc() and returns a pointer
@@ -220,6 +222,91 @@
 static void output_quoted_string(FILE *out, const char *z){
   int i;
   int nSingle = 0;
+  int zlen = strlen(z);
+  int blen = 0;      // add HEX mode
+  int hex_mode = 0;  // add HEX mode
+  int need_decode = 0;  // add HEX mode
+  int need_trim_header0 = 0;  // add HEX mode
+  unsigned char *bin_buf = 0;  // add HEX mode
+
+  // add HEX output mode
+//  if ( dump_mode !=2 )
+  {
+      for(i=zlen-1; i>=0; i--)
+      {
+          if ( i>=1 )
+           if (
+                ( (z[i] == 1) || (z[i] == 2) || (z[i] == 0x28) )
+                &&
+                ( z[i-1] == 1 )
+              )
+           {
+//**       0x00  ->  0x01 0x01
+//**       0x01  ->  0x01 0x02
+//**       0x27  ->  0x01 0x28
+              need_decode = 1;
+              hex_mode = 1;
+              // skip i-1
+              i--; 
+              continue;
+           }
+          if ( /*(z[i] >= 1) &&*/ ((unsigned char) z[i] <= 8) ) 
+           {  // my rule
+              hex_mode = 1;
+           }
+//        if ( (i != 0) && (z[i] == 1) ) { } // error ? or other rule
+          if ( (i == 0 ) && (z[i] == 1) )
+           {
+                // [0] 0x01 has no paire 
+                // perhaps php encode head
+                //  php/ext/sqlite/pdo_sqlite2.c : function sqlite2_handle_quoter
+                hex_mode = 1;
+                need_decode = 1;
+                need_trim_header0 = 1;
+           }
+      }
+
+      if ( hex_mode && (zlen > 0) )
+      {
+         if ( need_decode )
+          {
+             bin_buf = malloc( zlen + 1 );
+             if( bin_buf==0 )
+              {
+                fprintf(stderr,"hex_mode: out of memory!\n");
+                exit(1);
+              }
+            if ( need_trim_header0 )
+              blen = sqlite_decode_binary((unsigned char *) ( z + 1 ) , (unsigned char *) bin_buf);
+            else
+              blen = sqlite_decode_binary((unsigned char *) z , (unsigned char *) bin_buf);
+          }
+         else
+          {
+             bin_buf = (unsigned char *) z;
+             blen = zlen;
+          }
+
+         if ( blen > 0)
+             {
+                 fprintf(out,"X'");
+                 for(i=0; i < blen; i++)
+                 {
+                    fprintf(out,"%02x" , (unsigned char ) bin_buf[i]);
+                 }
+                 fprintf(out,"'");
+             }
+           else
+             {
+                 fprintf(out,"''");
+             }
+         if ( need_decode )
+            free(bin_buf);
+         return ;
+      }
+  }
+  // end add HEX output mode
+
   for(i=0; z[i]; i++){
     if( z[i]=='\'' ) nSingle++;
   }
@@ -415,19 +502,32 @@
   int i, n;
   int needQuote;
   char *z;
+  char quote_char;
 
   if( p->zDestTable ){
     free(p->zDestTable);
     p->zDestTable = 0;
   }
   if( zName==0 ) return;
-  needQuote = !isalpha(*zName) && *zName!='_';
+
+  if ( dump_mode != 2 )
+      {
+        quote_char = '"';
+        needQuote = 1;
+      }
+    else
+      {
+        quote_char = '\'';
+        needQuote = !isalpha(*zName) && *zName!='_';
+      }
+
   for(i=n=0; zName[i]; i++, n++){
-    if( !isalnum(zName[i]) && zName[i]!='_' ){
+    if( !needQuote && !isalnum(zName[i]) && zName[i]!='_' ){
       needQuote = 1;
-      if( zName[i]=='\'' ) n++;
     }
+    if( zName[i]==quote_char ) n++;
   }
+
   if( needQuote ) n += 2;
   z = p->zDestTable = malloc( n+1 );
   if( z==0 ){
@@ -435,12 +535,12 @@
     exit(1);
   }
   n = 0;
-  if( needQuote ) z[n++] = '\'';
+  if( needQuote ) z[n++] = quote_char;
   for(i=0; zName[i]; i++){
     z[n++] = zName[i];
-    if( zName[i]=='\'' ) z[n++] = '\'';
+    if( zName[i]==quote_char ) z[n++] = quote_char;
   }
-  if( needQuote ) z[n++] = '\'';
+  if( needQuote ) z[n++] = quote_char;
   z[n] = 0;
 }

chmod  700 ./configure
./configure --help
./configure --target=mingw32 --host=mingw32 --enable-static
gmake

 $dsn = 'sqlite:'.$db_name;
 if (file_exists($db_name))
 {
   $handle = fopen($db_name, "r");
   $head = fread($handle, 100);
   fclose($handle);

   $head_sqlite2 = '** This file contains an SQLite 2.1 database **';
   $head_sqlite3 = 'SQLite format 3';

   if (substr_compare($head , $head_sqlite2, 0, strlen($head_sqlite2)) == 0)
     {
       $dsn = 'sqlite2:'.$db_name;
     }
    else if (substr_compare($head , $head_sqlite3, 0, strlen($head_sqlite3)) == 0)
     {
       $dsn = 'sqlite:'.$db_name;
     }
 }

  $dbh = new PDO($dsn);
  //sqlite::memory:
  // sqlite:filename
  // sqlite2:filename