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 AB075DB298 for ; Fri, 28 Oct 2005 22:42:09 -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 40956-04 for ; Sat, 29 Oct 2005 01:42:04 +0000 (GMT) Received: from eastrmmtao03.cox.net (eastrmmtao03.cox.net [68.230.240.36]) by svr1.postgresql.org (Postfix) with ESMTP id 90B4DDB26C for ; Fri, 28 Oct 2005 22:42:06 -0300 (ADT) Received: from [192.168.0.17] (really [24.170.195.108]) by eastrmmtao03.cox.net (InterMail vM.6.01.05.02 201-2131-123-102-20050715) with ESMTP id <20051029014130.JUSZ2767.eastrmmtao03.cox.net@[192.168.0.17]>; Fri, 28 Oct 2005 21:41:30 -0400 From: Robert Treat To: pgsql-www@postgresql.org, Zet Subject: Re: which charset use for cyrilic? Date: Fri, 28 Oct 2005 21:42:10 -0400 User-Agent: KMail/1.6.2 References: <6BCB9D8A16AC4241919521715F4D8BCE92E7B7@algol.sollentuna.se> <11434880562.20051028204656@on.kg> In-Reply-To: <11434880562.20051028204656@on.kg> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="windows-1251" Content-Transfer-Encoding: quoted-printable Message-Id: <200510282142.10375.xzilla@users.sourceforge.net> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.004 required=5 tests=[AWL=0.004] X-Spam-Score: 0.004 X-Spam-Level: X-Archive-Number: 200510/116 X-Sequence-Number: 8704 On Friday 28 October 2005 12:46, Zet wrote: > 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 =3D '=F1=EB=EE=E2=EE' > > returns me a record, where a =3D '=F4=F0=E0=E7=E0' > > after I tried UNICODE > but for most of cyrilic words PG gives error like > "invalid byte sequence for encoding "UNICODE":..." > We barely get responses on this list for issues that are actually web relat= ed,=20 if you want an answer for this you better send it to pgsql-general! :-) =2D-=20 Robert Treat Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL