Changeset 319

Timestamp:

03/18/10 03:24:53 (23 months ago)

Author:

antonbatenev.ya.ru

Message:

Исправление ошибок с кодировкой и квотированием в скрипте перегона данных MySQL -> SQLite

File:

• test/mysql2sqlite/mysql2sqlite.php (modified) (3 diffs)

test/mysql2sqlite/mysql2sqlite.php

@@ -30 +30 @@
 //
 
-function quoteString ($param)
-{
-        return "'" . sqlite_escape_string($param) . "'";
-}
-
 if (file_exists($sqlite_filename) == true)
         unlink($sqlite_filename) or die ("can't delete file " . $sqlite_filename . "\n");
@@ -49 +44 @@
 }
 
+function quoteString ($param)
+{
+        global $sqlite_connection;
+        return $sqlite_connection->quote($param);
+}
+
 //
 // создание схемы БД
@@ -67 +68 @@
 $mysql_connection = mysql_connect($mysql_host, $mysql_user, $mysql_password) or die ("mysql_connect: " . mysql_error() . "\n");
 mysql_select_db($mysql_database, $mysql_connection) or die ("mysql_select_db : " . mysql_error($mysql_connection) . "\n");
+mysql_set_charset("utf8", $mysql_connection) or die ("mysql_set_charset : " . mysql_error($mysql_connection) . "\n");
 
 //