pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jouneau Luc <Luc.Jouneau@diamant.jouy.inra.fr>
To: Eduardo S. Fontanetti <dufuzzy@yahoo.com.br>
To: pgsql-admin@postgresql.org
Subject: Re: Problem saving some characters
Date: Mon, 21 Jun 2004 15:26:15 +0200
Message-ID: <00ea01c45793$544abe10$4703668a@pc502jlo> (raw)
References: <20040621130421.94999.qmail@web40701.mail.yahoo.com>

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" <dufuzzy@yahoo.com.br>
To: <pgsql-admin@postgresql.org>
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
>




view thread (3+ messages)

Message-ID: <00ea01c45793$544abe10$4703668a@pc502jlo>
Permalink:  ../00ea01c45793$544abe10$4703668a@pc502jlo/
Also on:    postgresql.org/message-id/00ea01c45793$544abe10$4703668a@pc502jlo

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: Luc.Jouneau@diamant.jouy.inra.fr, dufuzzy@yahoo.com.br
  Subject: Re: Problem saving some characters
  In-Reply-To: <00ea01c45793$544abe10$4703668a@pc502jlo>
  References: <20040621130421.94999.qmail@web40701.mail.yahoo.com> <00ea01c45793$544abe10$4703668a@pc502jlo>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox