[Erp5-report] r18530 - /erp5/trunk/products/ERP5Type/CachePlugins/SQLCache.py

[nobody at svn.erp5.org]

Author: kazuhiko
Date: Thu Dec 27 10:49:06 2007
New Revision: 18530

URL: http://svn.erp5.org?rev=18530&view=rev
Log:
use VARBINARY instead of VARCHAR for utf8 database.

Modified:
    erp5/trunk/products/ERP5Type/CachePlugins/SQLCache.py

Modified: erp5/trunk/products/ERP5Type/CachePlugins/SQLCache.py
URL: http://svn.erp5.org/erp5/trunk/products/ERP5Type/CachePlugins/SQLCache.py?rev=18530&r1=18529&r2=18530&view=diff
==============================================================================
--- erp5/trunk/products/ERP5Type/CachePlugins/SQLCache.py (original)
+++ erp5/trunk/products/ERP5Type/CachePlugins/SQLCache.py Thu Dec 27 10:49:06 2007
@@ -65,9 +65,9 @@
     
   cache_expire_check_interval = 3600
     
-  create_table_sql = '''CREATE TABLE %s(cache_id VARCHAR(970) NOT NULL, 
+  create_table_sql = '''CREATE TABLE %s(cache_id VARBINARY(970) NOT NULL, 
                                          value LONGTEXT,
-                                         scope VARCHAR(20),
+                                         scope VARBINARY(20),
                                          stored_at INT,
                                          cache_duration INT DEFAULT 0,
                                          calculation_time FLOAT,