X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EB8B9DB1EE for ; Fri, 28 Oct 2005 11:46:24 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 81919-03 for ; Fri, 28 Oct 2005 14:46:15 +0000 (GMT) Received: from mail.aknet.kg (ns1.aknet.kg [212.112.96.1]) by svr1.postgresql.org (Postfix) with ESMTP id DC6F3DB231 for ; Fri, 28 Oct 2005 11:46:13 -0300 (ADT) Received: (qmail 17330 invoked by uid 91); 28 Oct 2005 14:46:12 -0000 Received: from 212.112.107.15 by mail.aknet.kg (envelope-from , uid 82) with qmail-scanner-1.23st (spamassassin: 2.64. perlscan: 1.23st. Clear:RC:1(212.112.107.15):. Processed in 0.030592 secs); 28 Oct 2005 14:46:12 -0000 X-Qmail-Scanner-Mail-From: skyer@on.kg via mail.aknet.kg X-Qmail-Scanner: 1.23st (Clear:RC:1(212.112.107.15):. Processed in 0.030592 secs Process 17325) Received: from unknown (HELO MainComputer) (212.112.107.15) by mail.aknet.kg with SMTP; 28 Oct 2005 14:46:11 -0000 Date: Fri, 28 Oct 2005 20:46:56 +0400 From: Zet X-Mailer: The Bat! (v2.01) Reply-To: Zet Organization: UnCLouds X-Priority: 3 (Normal) Message-ID: <11434880562.20051028204656@on.kg> To: pgsql-www@postgresql.org Subject: which charset use for cyrilic? In-Reply-To: <6BCB9D8A16AC4241919521715F4D8BCE92E7B7@algol.sollentuna.se> References: <6BCB9D8A16AC4241919521715F4D8BCE92E7B7@algol.sollentuna.se> MIME-Version: 1.0 Content-Type: text/plain; charset=Windows-1251 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.074 required=5 tests=[AWL=0.074] X-Spam-Score: 0.074 X-Spam-Level: X-Archive-Number: 200510/112 X-Sequence-Number: 8700 Hi Which charset is need to be set in database for cyrilic? I've used till now WIN, but today I found a problem for example: SELECT * FROM table WHERE a = 'слово' returns me a record, where a = 'фраза' after I tried UNICODE but for most of cyrilic words PG gives error like "invalid byte sequence for encoding "UNICODE":..." Regards, Zet