Index: modules/locale/locale.install
===================================================================
RCS file: /cvs/drupal/drupal/modules/locale/locale.install,v
retrieving revision 1.6
diff -u -p -r1.6 locale.install
--- modules/locale/locale.install	1 Sep 2006 07:40:08 -0000	1.6
+++ modules/locale/locale.install	13 Nov 2006 09:45:27 -0000
@@ -18,6 +18,10 @@ function locale_install() {
         PRIMARY KEY (locale)
       ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
 
+      /* BIG NOTE! source is not used as a binary field!
+         non-mysql DBMS's need to ensure the field type is
+         text and that LIKE produces a case-sensitive
+         comparison */
       db_query("CREATE TABLE {locales_source} (
         lid int NOT NULL auto_increment,
         location varchar(255) NOT NULL default '',
@@ -26,6 +30,10 @@ function locale_install() {
         KEY source (source(30))
       ) /*!40100 DEFAULT CHARACTER SET UTF8 */ ");
 
+      /* BIG NOTE! translation is not used as a binary field!
+         non-mysql DBMS's need to ensure the field type is
+         text and that LIKE produces a case-sensitive
+         comparison */
       db_query("CREATE TABLE {locales_target} (
         lid int NOT NULL default '0',
         translation blob NOT NULL,
@@ -49,16 +57,24 @@ function locale_install() {
         PRIMARY KEY (locale)
       )");
 
+      /* BIG NOTE! source is not used as a binary field!
+         non-mysql DBMS's need to ensure the field type is
+         text and that LIKE produces a case-sensitive
+         comparison */
       db_query("CREATE TABLE {locales_source} (
         lid serial,
         location varchar(255) NOT NULL default '',
-        source bytea NOT NULL,
+        source text NOT NULL,
         PRIMARY KEY (lid)
       )");
 
+      /* BIG NOTE! translation is not used as a binary field!
+         non-mysql DBMS's need to ensure the field type is
+         text and that LIKE produces a case-sensitive
+         comparison */
       db_query("CREATE TABLE {locales_target} (
         lid int NOT NULL default '0',
-        translation bytea NOT NULL,
+        translation text NOT NULL,
         locale varchar(12) NOT NULL default '',
         plid int NOT NULL default '0',
         plural int NOT NULL default '0'