pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedProblem saving some characters
3+ messages / 3 participants
[nested] [flat]
* Problem saving some characters
@ 2004-06-21 13:04 Eduardo S. Fontanetti <dufuzzy@yahoo.com.br>
2004-06-21 13:26 ` Re: Problem saving some characters Jim Seymour <jseymour@linxnet.com>
2004-06-21 13:26 ` Re: Problem saving some characters Jouneau Luc <Luc.Jouneau@diamant.jouy.inra.fr>
0 siblings, 2 replies; 3+ messages in thread
From: Eduardo S. Fontanetti @ 2004-06-21 13:04 UTC (permalink / raw)
To: pgsql-admin
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/
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Problem saving some characters
2004-06-21 13:04 Problem saving some characters Eduardo S. Fontanetti <dufuzzy@yahoo.com.br>
@ 2004-06-21 13:26 ` Jim Seymour <jseymour@linxnet.com>
1 sibling, 0 replies; 3+ messages in thread
From: jseymour@linxnet.com @ 2004-06-21 13:26 UTC (permalink / raw)
To: pgsql-admin
"=?iso-8859-1?q?Eduardo=20S.=20Fontanetti?=" <dufuzzy@yahoo.com.br> 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Problem saving some characters
2004-06-21 13:04 Problem saving some characters Eduardo S. Fontanetti <dufuzzy@yahoo.com.br>
@ 2004-06-21 13:26 ` Jouneau Luc <Luc.Jouneau@diamant.jouy.inra.fr>
1 sibling, 0 replies; 3+ messages in thread
From: Jouneau Luc @ 2004-06-21 13:26 UTC (permalink / raw)
To: Eduardo S. Fontanetti <dufuzzy@yahoo.com.br>; 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@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
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-06-21 13:26 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-21 13:04 Problem saving some characters Eduardo S. Fontanetti <dufuzzy@yahoo.com.br>
2004-06-21 13:26 ` Jim Seymour <jseymour@linxnet.com>
2004-06-21 13:26 ` Jouneau Luc <Luc.Jouneau@diamant.jouy.inra.fr>
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