Thread: Extended display and extended ascii characters

Linux ...... 2.2.19pre17 #1 Tue Mar 13 22:37:59 EST 2001 i586 unknown
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.4
$ /usr/lib/postgresql/bin/pg_controldata /var/lib/postgres/data
[cut]
LC_COLLATE:                           it_IT
LC_CTYPE:                             it_IT



I created a table (bibl) from the following txt file containing extended
ascii chars (environment Latin1). If I do a:
=> select * from bibl;
the contents of the table will display all right, but if (in order to
gain scrolling capacity) I try:
=> \x      ## turn expanded display on
=> select * from bibl;
strange characters will appear in place of original accented letters.

TEXT FILE:
---------
autore | titolo | altre_notizie | collana

 TOUTAIN J.                                    | L'économie antique
                                                            | [Pr. acq. FB 377, pc. FB 400]
                                                                             | L'Évolution de l'Humanité. Synthèse
Collect.Dirigée par Henri Beer 
 ZWIRNER Giuseppe                              | Istituzioni di Matematiche per gli studenti delle facoltà di chimica,
agraria,scienze naturali, economia e commercio e statistica. | Parte prima: rist. dell'ottava ediz. riveduta ed
ampliatacon numerosi esercizi e problemi risolti e proposti. 1973. Parte sec. 4^ ed.  |  
 BARRATT BROWN Michael                         | Storia economica dell'imperialismo
                                                            | Tit. or. «After Imperialism» (1970). Tr. di Mirella
Miotti.Edizione italiana a cura di Alberto Martinelli. Con 33 tabelle fuori testo. | Storia e classe. 17 
(3 rows)
----------------
AND SOME TECHNICAL INFO:
-----------------------
Linux ...... 2.2.19pre17 #1 Tue Mar 13 22:37:59 EST 2001 i586 unknown
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.95.4
$ /usr/lib/postgresql/bin/pg_controldata /var/lib/postgres/data
[cut]
LC_COLLATE:                           it_IT
LC_CTYPE:                             it_IT
-----------------------
Please also note that:
If I read the text file with 'less' or 'vim' the accented letters will
display well; whereas hexediting it, they are displayed as '.'s.

                ~~~~~~~
Could any of you explain what is causing the mess?
Thanks for the attention.
    Ennio.

* Ennio-Sr <nasr.laili@tin.it> [270303, 20:22] wrote:

> I created a table (bibl) from the following txt file containing extended
> ascii chars (environment Latin1). If I do a:
[cut]

Lacking an answer whatsoever from the list, I conducted further tests
combining in different fashion server character set and client encoding
but the result is always the same:
toggling the *expanded display* on hampers translation of some char
codes. With *expanded* turned off, the glyphs are correct whereas
if it is *on* the hex codes are displayed instead.

Could any of the participants to this ML give some suggestion?
Did any of you ever experienced such a behaviour?
Could somebody suggest which source file I should look at to try to
understand what goes on?

Thank you for your attention.
Regards,
    Ennio.

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