ORDER BY and accents
От | Roberto Cantanhede |
---|---|
Тема | ORDER BY and accents |
Дата | |
Msg-id | 3BB8FB17.B2BD289F@yawl.com.br обсуждение исходный текст |
Список | 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 по дате отправления: