Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8BKX7764960 for ; Tue, 11 Sep 2001 16:33:07 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f8BKFUf81466 for pgsql-sql@postgresql.org; Tue, 11 Sep 2001 16:15:30 -0400 (EDT) (envelope-from news) From: domingo@dad-it.com (Domingo Alvarez Duarte) X-Newsgroups: comp.databases.postgresql.sql Subject: using LATIN1 ? Date: 11 Sep 2001 13:15:21 -0700 Organization: http://groups.google.com/ Lines: 18 Message-ID: <70a76315.0109111215.33300e16@posting.google.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200109/83 X-Sequence-Number: 4739 I've compiled postgresql with multi-byte support, and created a database with: create database l1 with encoding 'LATIN1'; It was created succefull. I started "psql l1" and issued this query "select upper('á')" and get back "á" expected "Á". I created a table with "create table test(f varchar(50));" I inserted this values "insert into test(f) values('áé');" It was ok now "select upper(f) from test;" gave me back "áé" -> expected "ÁÉ"; what's the problem ?