Re: PostgreSQL encoding question

From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
To: Anton Kalauzky <kalauzky(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgreSQL(dot)org, pgsql-general(at)postgreSQL(dot)org
Subject: Re: PostgreSQL encoding question
Date: 2000-10-10 13:52:07
Message-ID: Pine.GSO.3.96.SK.1001010164754.381s-100000@ra
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Anton,

you can communicate with me in Russian.
Quick questions:
1. what's the ouput of 'psql -l'
2. Did you compile postgresql yourself and which options you
used.
3. did you setup locale environment before starting
postmaster
4. Could you check if locale is working on your systems

Regards,

Oleg
On Sat, 7 Oct 2000, Anton Kalauzky wrote:

> Date: Sat, 07 Oct 2000 08:58:42 GMT
> From: Anton Kalauzky <kalauzky(at)hotmail(dot)com>
> To: pgsql-admin(at)postgreSQL(dot)org, pgsql-general(at)postgreSQL(dot)org
> Subject: [ADMIN] PostgreSQL encoding question
>
> Dear friends,
>
> I have two PC's with exactly the same configurations - one in my office and
> the other at home. They are running RedHat Linux 6.2 and PostgreSQL included
> in distribution. The first one I recently installed by upgrading from Linux
> 6.1 and the for the second one I went through full installation process.
>
> I have also exactly the same db's, tables and row's in PostgreSQL. All my
> data's are completely equal. Recently found that when I invoke SQL command
> "SELECT * FROM nst ORDER BY name;" I have different answers on my systems. I
> would like to mention that I use KOI8 (RUSSIAN) encoding. The 1-st one puts
> English before Russian, it's ok because they have less ASCII codes. But the
> 2-nd one is little strange. It sorts Russian characters truely but puts
> digits and English after Russian. Here it is some outscreen:
>
> SELECT name,id FROM nst ORDER BY name;
> -----------
> ВИНО
> МОНИТОР
> ВИНО 1971
> МОНИТОР 15"
> Telephone
> Windows
>
> I found some SET commands but they didn't gave me any result.
>
> So, do you have any idea about solving this problem? Thank you for your
> time.
>
> All the best.
> Anton Kalauzki
> _________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
> Share information about yourself, create your own public profile at
> http://profiles.msn.com.
>

_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2000-10-10 16:33:59 Re: foreign key question: the backend end the connection
Previous Message lt 2000-10-10 11:58:42 foreign key question: the backend end the connection

Browse pgsql-general by date

  From Date Subject
Next Message Trewern, Ben 2000-10-10 14:03:23 Listing Triggers corresponding to foreign keys
Previous Message Marc SCHAEFER 2000-10-10 13:51:30 Some advanced database features, are they present in PostgreSQL