| 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: | Whole Thread | Raw Message | 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 ?
| 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. |