Skip site navigation (1) Skip section navigation (2)

ORDER BY and accents

From: Roberto Cantanhede <robertoc(at)yawl(dot)com(dot)br>
To: pgsql-cygwin(at)postgresql(dot)org
Subject: ORDER BY and accents
Date: 2001-10-01 23:24:07
Message-ID: 3BB8FB17.B2BD289F@yawl.com.br (view raw or flat)
Thread:
Lists: pgsql-cygwin
Hi all,

    I've installed Cygwin in October 1st, build Postgres from the
sources supplied with cygwin as described in
\usr\doc\postgresql-7.1.3\html\charset.html. I've set the following
variables at /etc/profile, as a result I get:
$ set | grep pt
    LANG=pt_BR
    LC_ALL=pt_BR
    LC_COLLATE=pt_BR
    LC_CTYPE=pt_BR
I used  the following options with configure
$ ./configure --enable-locale --with-java --with-python --enable-odbc
--enable-syslog --with-tclconfig=/usr/lib --with-tk-config=/usr/lib
--with-includes=/usr/include --with-libraries=/usr/lib
--enable-multibyte=LATIN1 --with-CXX --prefix=/usr --sysconfdir=/etc
--docdir=/usr/doc/postgresql-$version

(have --with-tcl worked for you? not to me; yes, tcl/tk package is
installed and I fixed the makefile.shlib)

I created the database with:
initdb -D /usr/local/pgsql/data -E LATIN1

and created the database with:
createdb james -E LATIN1

Then, I run the following script:
--
-- Selected TOC Entries:
--
\connect - Administrator
--
-- TOC Entry ID 2 (OID 18732)
--
-- Name: teste Type: TABLE Owner: Administrator
--

CREATE TABLE "teste" (
        "linha" text
);

--
-- Data for TOC Entry ID 3 (OID 18732)
--
-- Name: teste Type: TABLE DATA Owner: Administrator
--


COPY "teste"  FROM stdin;
Ana
Eva
Ivone
Otameire
Uilma
Wania
Yara
Ângela
Élimei
Íngride
Ôosamia
Úrd
\.

with "psql -d james -f script.dmp

After connecting to the database with psql
select * from teste order by linha;
And I get the following result
Ana
Eva
Ivone
Otameire
Uilma
Wania
Yara
Ângela
Élimei
Íngride
Ôosamia
Úrd
Instead of Ana Ângela Eva Élimei, Ivone, Íngride etc. I get the correct
characters and cygwin 'make' messages are correctly displayed in
Brazilian Portugese.

Any suggestions?

    Roberto


pgsql-cygwin by date

Next:From: Gerhard HäringDate: 2001-10-02 03:45:35
Subject: Re: Building natively on win32 with mingw32/Cygwin
Previous:From: Jason TishlerDate: 2001-10-01 16:28:55
Subject: Re: ipc-daemon initdb postmaster

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group