using LATIN1 ?

Поиск
Список
Период
Сортировка
От domingo@dad-it.com (Domingo Alvarez Duarte)
Тема using LATIN1 ?
Дата
Msg-id 70a76315.0109111215.33300e16@posting.google.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Gledatelj"
Дата:
Сообщение: Re: Combine query views into one SQL string
Следующее
От: yaubi@yaubi.com (Yoann)
Дата:
Сообщение: Which SQL query makes it possible to optain the 3 greatest values of an interger list ?