ent_encoding to 'latin2';
SET VARIABLE
Robert> Hmm, what did you say I should write? Well, this is PG6.5.2
Robert> installed from RPM, should it be compiled with some special
Robert> option? Thanks.
Yes, postgres must be compiled with --enable-locale and --with-mb=LA
Robert> - Robert
Just do:
set client encoding to 'WIN1250';
Server will store its data in iso-8859-2, but will recode input and
output for windoze clients.
The reason is, that postgres database server uses locales to sort tables
and there is no 'cs_CZ.WIN-1250'
// and use czech locale
set locale es;
select * from table2 order by 2; // this will sort using spanish locale
thanks,
David
--
* David Sauer, student of Czech Technical University
