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
