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