From c3a98825184619e1cb7d4d03d07fc0ba399d2205 Mon Sep 17 00:00:00 2001 From: fisharebest Date: Sat, 10 Apr 2010 16:54:27 +0000 Subject: Need to specify database collation on wt_place_location table --- modules/googlemap/db_schema/db_schema_0_1.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'modules') diff --git a/modules/googlemap/db_schema/db_schema_0_1.php b/modules/googlemap/db_schema/db_schema_0_1.php index ac084c43ed..7b26dba40c 100644 --- a/modules/googlemap/db_schema/db_schema_0_1.php +++ b/modules/googlemap/db_schema/db_schema_0_1.php @@ -55,7 +55,7 @@ if (!WT_DB::table_exists("{$TBLPREFIX}placelocation")) { " pl_zoom INTEGER NULL,". " pl_icon VARCHAR(255) NULL,". " PRIMARY KEY (pl_id)". - ") ".self::$UTF8_TABLE + ") COLLATE utf8_unicode_ci ENGINE=InnoDB" ); self::exec("CREATE INDEX {$TBLPREFIX}pl_level ON {$TBLPREFIX}placelocation (pl_level )"); self::exec("CREATE INDEX {$TBLPREFIX}pl_long ON {$TBLPREFIX}placelocation (pl_long )"); -- cgit v1.3