select mime_charset from ad_locales where locale = :locale select locale from ad_locales where language = '[db_quote $language]' and enabled_p = 't' and (default_p = 't' or (select count(*) from ad_locales where language = '[db_quote $language]') = 1 ) select label from ad_locales where lower(locale) = lower(:locale) select label, locale from ad_locales order by label select iso_639_2 from language_639_2_codes where iso_639_1 = :language select iso_639_2 from language_639_2_codes where iso_639_2 = :language select label from language_639_2_codes where iso_639_1 = :language select label from language_639_2_codes where iso_639_2 = :language