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 5950AD1B1CD for ; Mon, 21 Jun 2004 10:26:12 -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 94727-08 for ; Mon, 21 Jun 2004 13:26:07 +0000 (GMT) Received: from jimsun.linxnet.com (jimsun.linxnet.com [64.32.196.134]) by svr1.postgresql.org (Postfix) with ESMTP id 39C38D1B1C8 for ; Mon, 21 Jun 2004 10:26:02 -0300 (ADT) Received: by jimsun.linxnet.com (Postfix, from userid 332) id A42D84310; Mon, 21 Jun 2004 09:26:05 -0400 (EDT) To: pgsql-admin@postgresql.org Subject: Re: Problem saving some characters X-Sun-Charset: US-ASCII Reply-To: pgsql-admin@postgresql.org In-Reply-To: <20040621130421.94999.qmail@web40701.mail.yahoo.com> Message-Id: <20040621132605.A42D84310@jimsun.linxnet.com> Date: Mon, 21 Jun 2004 09:26:05 -0400 (EDT) From: jseymour@linxnet.com (Jim Seymour) 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/279 X-Sequence-Number: 13939 "=?iso-8859-1?q?Eduardo=20S.=20Fontanetti?=" wrote: > > 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". [snip] That's because back-slashes are escape characters to pgsql. You need to escape them (yes: escape the escape chars) in order to get them into the db. This also means that anytime you may wish to search on these, you'll have to properly escape the escapes. And so-on. I believe if you thoroughly peruse the docs, you'll find this noted. Jim