X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 22D50D1B21B for ; Mon, 21 Jun 2004 10:26:36 -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 97464-09 for ; Mon, 21 Jun 2004 13:26:38 +0000 (GMT) Received: from jais.jouy.inra.fr (jais.jouy.inra.fr [138.102.1.17]) by svr1.postgresql.org (Postfix) with ESMTP id 93F17D1B1CD for ; Mon, 21 Jun 2004 10:26:31 -0300 (ADT) Received: from diamant.jouy.inra.fr (localhost [127.0.0.1]) by jais.jouy.inra.fr (8.10.1/8.10.1) with ESMTP id i5LDQUs11937 for ; Mon, 21 Jun 2004 15:26:31 +0200 (CEST) Received: from pc502jlo (pc502ljo [138.102.3.71]) by diamant.jouy.inra.fr (8.10.1/8.10.1) with SMTP id i5LDQCf19448; Mon, 21 Jun 2004 15:26:12 +0200 (CEST) Message-ID: <00ea01c45793$544abe10$4703668a@pc502jlo> From: "Jouneau Luc" To: "Eduardo S. Fontanetti" , References: <20040621130421.94999.qmail@web40701.mail.yahoo.com> Subject: Re: Problem saving some characters Date: Mon, 21 Jun 2004 15:26:15 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/280 X-Sequence-Number: 13940 Hello, '\' is an escape character, you should double it when you insert data : insert into my_table values ('S:\\directory\\app'); I don't think it has much to do with database encoding. Luc Jouneau ----- Original Message ----- From: "Eduardo S. Fontanetti" To: Sent: Monday, June 21, 2004 3:04 PM Subject: [ADMIN] Problem saving some characters > Hello, > > I am trying to save a directory name on the Postgres, > but it is "cutting" some characters, and the result is > being diferent, and then, my app don't work properly. > > Example: > > I am trying to save "S:\directory\app" to a text field > on the Postgres. > When I do a Select, it returns "S:directoryapp". > > It could be caused by the encoding type? I am using > the Latin2. > > Somebody could help me? Whatever, it could be from the > ODBC driver, but I don't know how to test it. > > Thanks! > > Eduardo S. Fontanetti > > ______________________________________________________________________ > > Yahoo! Mail - agora com 100MB de espaço, anti-spam e antivírus grátis! > http://br.info.mail.yahoo.com/ > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faqs/FAQ.html >