using LATIN1 ?

From: domingo(at)dad-it(dot)com (Domingo Alvarez Duarte)
To: pgsql-sql(at)postgresql(dot)org
Subject: using LATIN1 ?
Date: 2001-09-11 20:15:21
Message-ID: 70a76315.0109111215.33300e16@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?

Browse pgsql-sql by date

  From Date Subject
Next Message Kevin Way 2001-09-12 01:24:35 Re: table inheritance and foreign key troubles
Previous Message trebischt 2001-09-11 18:47:03 To query many tables.