Skip site navigation (1) Skip section navigation (2)

Re: Problem saving some characters

From: "Jouneau Luc" <Luc(dot)Jouneau(at)diamant(dot)jouy(dot)inra(dot)fr>
To: "Eduardo S(dot) Fontanetti" <dufuzzy(at)yahoo(dot)com(dot)br>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: Problem saving some characters
Date: 2004-06-21 13:26:15
Message-ID: 00ea01c45793$544abe10$4703668a@pc502jlo (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)yahoo(dot)com(dot)br>
To: <pgsql-admin(at)postgresql(dot)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
>


In response to

pgsql-admin by date

Next:From: Bender, CherylDate: 2004-06-21 15:22:25
Subject: Re: pgadminII error in connecting to PostgreSQL Server
Previous:From: Jim SeymourDate: 2004-06-21 13:26:05
Subject: Re: Problem saving some characters

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group