using LATIN1 ? - Mailing list pgsql-sql

From domingo@dad-it.com (Domingo Alvarez Duarte)
Subject using LATIN1 ?
Date
Msg-id 70a76315.0109111215.33300e16@posting.google.com
Whole thread Raw
List pgsql-sql
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 ?


pgsql-sql by date:

Previous
From: "Gledatelj"
Date:
Subject: Re: Combine query views into one SQL string
Next
From: yaubi@yaubi.com (Yoann)
Date:
Subject: Which SQL query makes it possible to optain the 3 greatest values of an interger list ?