Received: from relay.gcom.ru (Garant-Siberia-RadioNET.gcom.ru [194.84.180.33] (may be forged)) by hub.org (8.8.8/8.7.5) with ESMTP id CAA04351 for ; Wed, 11 Mar 1998 02:12:13 -0500 (EST) Received: from avd.garsib.ru (avd.garsib.ru [194.135.7.99]) by relay.gcom.ru (8.6.10/8.6.10) with ESMTP id NAA08557; Wed, 11 Mar 1998 13:10:28 +0600 Received: (from avd@localhost) by avd.garsib.ru (8.8.7/8.8.7) id NAA00350; Wed, 11 Mar 1998 13:11:56 +0600 (NS) (envelope-from avd) To: Tsopa Denis Vladimirovich , pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] Re: [QUESTIONS] ODBC converts text fields? References: From: Aleksey Demakov Date: 11 Mar 1998 13:11:54 +0600 In-Reply-To: The Hermit Hacker's message of Tue, 10 Mar 1998 22:22:33 -0400 (AST) Message-ID: <867m614s78.fsf@avd.garsib.ru> Lines: 23 X-Mailer: Gnus v5.3/Emacs 19.34 > On Tue, 10 Mar 1998, Tsopa Denis Vladimirovich wrote: > > > Hi, All! > > > > I work with PostgreSQL (6.3) via PostODBC (0.35a). I use Builder C++ on > > Windows 95 as a PostgreSQL frontend. When I try to insert row into > > PostgreSQL table using SQL command 'INSERT' via ODBC driver, I get > > a trouble. The text string in inserted row is in cyrillic code page (KOI8R) > > and ODBC driver coverts this string to another code. > > What do I have to make to avoid it? > > Thanx. AFAIK, the PostODBC driver does not perform any character translations. Though I have seen something about recoding in the PostgreSQL 6.3 (see postgresql-6.3/src/data). I don't yet looked closer at this. BTW, how do you get koi8 under windows? Do you recode text by yourself from the windows encoding before sending it to postgres? And when you get the text back do you recode it back? -- Aleksey Demakov