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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-cygwin by date

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