Re: Psql 'Expanded display (\x)' behaviour

> Ennio-Sr writes:
>=20
> > toggling on/off the 'Expanded display' (in psql) does affect the display
> > of non-ascii chars.
>=20
> Not at all.  It's only an alternative table format.

Yes, but when I try to display this 'alternative table format' I found
that some of the chars (precisely those not in ascii 0-127) loose the
appearance ('glyph') they have when expanded display is off!

OK, I'll try to better explain what I mean:
I enter my db with $ psql mydb, then _I create a test table:_

mydb=3D#create table pro_chars (code text, glyph text);

and _insert some values:_

mydb=3D#insert into pro_chars values ('ALT+176', '=B0');
mydb=3D#insert into pro_chars values ('ALT+177', '=B1');
mydb=3D#insert into pro_chars values ('ALT+178', '=B2');
mydb=3D#insert into pro_chars values ('ALT+171', '=AB');
mydb=3D#insert into pro_chars values ('ALT+187', '=BB');
mydb=3D#insert into pro_chars values ('ALT+233', '=E9');
mydb=3D#insert into pro_chars values ('A with grave', '=E0');

(I typed the code values as you read them and the glyphs (which won't
display on your screen if you aren't in Latin1, perhaps) pressing in
turn: apostrophe, LeftAltKey + numbers on numerical keypad, apostrophe.)

Finally I _display my table:_

mydb=3D#select * from pro_chars;

and _everything is ok_, i.e. correct glyphs corresponding to the codes
are displayed.

Then I _toggle on the expanded display:_

mydb=3D#\x=20

and again:

mydb=3D#select * from pro_chars;

but (in the glyph column) I get, respectively: 0, 1, 2, +, ;,  , 1

Could you please reproduce this on your PC and see what happens?

> Perhaps the problem is that the pager does not handle the accented
> characters right.

Ehm ... I don't think pager has anything to do with the chars; I quoted
it only to underline the necessity for me to use 'Expanded display on'
as the only mean to see one page at a time, since I verified that pager
is not working with my tables!
It doesn't even work with the display of history: if I do:
mydb=3D# \s
the whole history will scroll on my screen and I'll be able to see last
page only! I read somewhere (/usr/share/doc/postgres-doc?) that pager
is not very reliable as to the correct judgement on where to stop!

Thanks for your attention, Peter.
Regards,
    Ennio.
--=20
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo.     \\?=
//
 Fa' qualche cosa di cui non sei capace!"   (diceva Henry Miller) ]     (=
=B0|=B0)
[Why to use Win$ozz (I say) if ... "even a fool can do that.             )=
=3D(
 Do something you aren't good at!" (used to say Henry Miller) ]