From 189bd65251fb62dab17d60786dbdf810fba55c1b Mon Sep 17 00:00:00 2001 From: Jan Schneider Date: Fri, 29 Jan 2010 15:45:24 +0100 Subject: [PATCH] Make this actually work. --- horde/scripts/upgrades/2009-04-13_horde_pgsql_upgrade.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/horde/scripts/upgrades/2009-04-13_horde_pgsql_upgrade.sql b/horde/scripts/upgrades/2009-04-13_horde_pgsql_upgrade.sql index 68f0d646f..d4035e5e8 100644 --- a/horde/scripts/upgrades/2009-04-13_horde_pgsql_upgrade.sql +++ b/horde/scripts/upgrades/2009-04-13_horde_pgsql_upgrade.sql @@ -1,3 +1,3 @@ -- Replace 'UTF8' with the encoding used in your database. -- This script is tested with Postgres 8.3+. -ALTER TABLE horde_prefs ALTER COLUMN pref_value TYPE BYTEA USING encode(convert_to(pref_value, 'UTF8'), 'escape'); +ALTER TABLE horde_prefs ALTER COLUMN pref_value TYPE BYTEA USING CAST(ENCODE(CONVERT_TO(pref_value, 'UTF8'), 'escape') AS BYTEA); -- 2.11.0