Index: openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.10.0d2-5.10.0d3.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/oracle/upgrade/Attic/upgrade-5.10.0d2-5.10.0d3.sql,v diff -u -N -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.10.0d2-5.10.0d3.sql 14 Mar 2019 10:23:05 -0000 1.1.2.1 +++ openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.10.0d2-5.10.0d3.sql 14 Mar 2019 10:41:42 -0000 1.1.2.2 @@ -4,6 +4,9 @@ alter table ad_locales modify column language varchar2(3); +-- normalize eventual padding from previous life as a char(n) +update ad_locales set language = trim(language); + create or replace view enabled_locales as select * from ad_locales where enabled_p = 't';