Changeset 2954
- Timestamp:
- 06/21/06 09:37:16 (17 years ago)
- Location:
- pykota/trunk
- Files:
-
- 4 modified
Legend:
- Unmodified
- Added
- Removed
-
pykota/trunk/initscripts/mysql/pykota-mysql.sql
r2903 r2954 31 31 -- Create the print quota database 32 32 -- 33 CREATE DATABASE pykota ;33 CREATE DATABASE pykota DEFAULT CHARACTER SET 'utf8'; 34 34 35 35 -- -
pykota/trunk/initscripts/postgresql/pykota-postgresql.sql
r2817 r2954 31 31 -- Create the print quota database 32 32 -- 33 CREATE DATABASE pykota ;33 CREATE DATABASE pykota WITH ENCODING='UTF-8'; 34 34 35 35 -- -
pykota/trunk/pykota/storages/mysqlstorage.py
r2874 r2954 50 50 self.database.autocommit(1) 51 51 self.cursor = self.database.cursor() 52 self.cursor.execute("SET NAMES 'utf8';") 52 53 self.cursor.execute("SET TRANSACTION ISOLATION LEVEL READ COMMITTED;") # Same as PostgreSQL and Oracle's default 53 54 self.closed = 0 -
pykota/trunk/pykota/storages/pgstorage.py
r2874 r2954 54 54 self.database = pg.connect(host=host, port=port, dbname=dbname, user=user, passwd=passwd) 55 55 self.closed = 0 56 self.database.query("SET CLIENT_ENCODING TO 'UTF-8';") 56 57 self.tool.logdebug("Database opened (host=%s, port=%s, dbname=%s, user=%s)" % (host, port, dbname, user)) 57 58