Changeset 752 for ZMS/trunk/zmssqldb.py

Timestamp:

26.10.2009 17:53:28 (3 years ago)

Author:

chris

Message:

zms-2.11.4-02

File:

• ZMS/trunk/zmssqldb.py (modified) (2 diffs)

ZMS/trunk/zmssqldb.py

@@ -24 +24 @@
 # Imports.
 from __future__ import nested_scopes
-from Globals import HTML, HTMLFile
+from App.special_dtml import HTMLFile
 from Products.ZSQLMethods.SQL import SQLConnectionIDs
 import copy
@@ -223 +223 @@
     def getDA(self):
       da = getattr(self,self.connection_id)
+      # Try to re-connect if not connected.
+      try: 
+        dbc = da._v_database_connection 
+      except AttributeError: 
+        da.connect(da.connection_string) 
+        dbc = da._v_database_connection
+      # Try to set character-set to utf-8 (should at least work on MySql).
+      try:
+        dbc.query('SET NAMES utf8') 
+        dbc.query('SET CHARACTER SET utf8')
+      except:
+        pass
       return da