psql - postgresql - how to align columns when selecting cyrillic text (utf-8)? -

my database utf-8. when selecting text field table looks this:

postgres=#  select '>'||exp_type||'<', exp_id t_exp_types exp_id in (3,11,12,15); +-----------------------------------------+--------+ |                ?column?                 | exp_id | +-----------------------------------------+--------+ | >храна<                            |      3 | | >почивка<                        |     11 | | >превод<                          |     12 | | >изравнителен превод< |     15 | +-----------------------------------------+--------+ (4 rows) 

how can make columns aligned properly? psql (postgresql) 9.1.3

solution: locale lc_all set 'c'. changing lc_all= fixed problem

it works fine here:

regress=> t_exp_types(exp_id, exp_type) (values (3, 'храна'), (11, 'почивка'), (12, 'превод'), (15, 'изравнителен превод')) regress-> select '>'||exp_type||'<', exp_id t_exp_types exp_id in (3,11,12,15);        ?column?        | exp_id  -----------------------+--------  >храна<               |      3  >почивка<             |     11  >превод<              |     12  >изравнителен превод< |     15 (4 rows) 

fedora 19, konsole 2.11.2 kde 4.11.2. locale is:

$ locale lang=en_us.utf-8 lc_ctype="en_us.utf-8" lc_numeric="en_us.utf-8" lc_time="en_us.utf-8" lc_collate="en_us.utf-8" lc_monetary="en_us.utf-8" lc_messages="en_us.utf-8" lc_paper="en_us.utf-8" lc_name="en_us.utf-8" lc_address="en_us.utf-8" lc_telephone="en_us.utf-8" lc_measurement="en_us.utf-8" lc_identification="en_us.utf-8" lc_all= 

odd symptoms, though; simple client_encoding mismatch mangle characters, not whitespace.