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