- There's no consistent use of upper/lower case in the locale and language columns of the ad_locales table so we need to do case insensitive searches. - ad_locales defines the language column as char(3). Searches for 2-letter language codes fail because (at least on PG) all 2-letter entries have a trailing space in the database.