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
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 |