From: | "Anton Kalauzky" <kalauzky(at)hotmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgreSQL(dot)org, pgsql-general(at)postgreSQL(dot)org |
Subject: | PostgreSQL encoding question |
Date: | 2000-10-07 08:58:42 |
Message-ID: | F819IuXZ2y2Fko8C7wy00009ae9@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff MacDonald | 2000-10-07 15:44:40 | Re: Re(2): Crontab and PostgreSQL Backup |
Previous Message | William L James | 2000-10-06 21:03:12 | timestamp data type and null value |
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Jacobs | 2000-10-07 10:57:53 | Re: Newbie, Howto access Array-Slots in user defined functions? |
Previous Message | Tom Lane | 2000-10-07 04:27:56 | Re: Newbie, Howto access Array-Slots in user defined functions? |