select fractional_digits, html_entity from currency_codes where iso = :currency select distinct tz, gmt_offset from timezones order by tz