X-Original-To: pgadmin-support-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id EEFC3D1B51A for ; Tue, 11 Nov 2003 02:03:00 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 35858-01 for ; Mon, 10 Nov 2003 22:02:33 -0400 (AST) Received: from inetrt.skcapi.co.jp (inetrt.skcapi.co.jp [219.163.131.10]) by svr1.postgresql.org (Postfix) with ESMTP id 59D52D1B506 for ; Mon, 10 Nov 2003 22:02:28 -0400 (AST) Received: from w2k (firewall.skcapi.co.jp [219.163.131.14]) by inetrt.skcapi.co.jp (8.11.4+3.4W/3.7Wpl2ps/02050922) with SMTP id hAB20YR51942; Tue, 11 Nov 2003 11:00:34 +0900 (JST) Message-ID: <020201c3a7f7$1b218c50$1f324d80@w2k> From: "Hiroshi Saito" To: "Andreas Pflug" , "=?Windows-1251?B?xOzo8vDo6SDP7u/u4g==?=" Cc: References: <947980921.20031110115514@mail.ru> <3FB02583.7070203@pse-consulting.de> Subject: Re: Bug Date: Tue, 11 Nov 2003 10:57:04 +0900 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1251" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/35 X-Sequence-Number: 2396 Dear Дмитрий Попов . I believe the reappearance of this problem. IMHO,You must not use multi-byte for the user ID. It seems you that it that a user was made under the condition of the multi-byte connection is right by the intervention of conversion. However, The user character line won't correspond so far as conversion is never minded at the time of the connection connection. regards, Hiroshi Saito ----- Original Message ----- From: "Andreas Pflug" To: "Дмитрий Попов" Cc: Sent: Tuesday, November 11, 2003 8:55 AM Subject: Re: [pgadmin-support] Bug > Дмитрий Попов wrote: > > >pgAdmin III, v1.0.0, pgSql 7.3.1 Windows Russian > > > >Hello! > > > >PostrgeSQL on windows make SuperUser's name symbols as current system > >user. When user in windows include russian, PgSQL make user with > >russian symbols too. > >But pgAmin replace it to "_". > > > > > >For Example: My user was "Dmitriy" (Дмитрий). There is PgSQL error: > >'Uncknown user "_______"'. > > > >I know, that russian usernames it's bad, but differnt other pgSQL > >manager's (like EMS PostrgeSQL manager) work with russian names > >correct. > > > > > > > > > > > Hi Dmitriy, > > actually I didn't understand exactly what the problem is, so I'm > guessing that you got a conversion problem. Do you have SQL_ASCII as > database encoding? If yes, this is a problem, because Russian characters > are not ascii. > There are two options: > > 1) (the better option) > use UNICODE or the Russian encoding in the database. > > 2) Use a newer pgAdmin3 version, we have a new workaround for SQL_ASCII > databases with wrong characters. > > Regards, > Andreas > > >P.S. Sorry for my English - i'm from Russia and speak English very > >bad. > >