'\' 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.
----- Original Message -----
From: "Eduardo S. Fontanetti" <dufuzzy(at)yahoo(dot)com(dot)br>
Sent: Monday, June 21, 2004 3:04 PM
Subject: [ADMIN] Problem saving some characters
> 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.
> 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.
> Eduardo S. Fontanetti
> Yahoo! Mail - agora com 100MB de espaço, anti-spam e antivírus grátis!
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
In response to
pgsql-admin by date
|Next:||From: Bender, Cheryl||Date: 2004-06-21 15:22:25|
|Subject: Re: pgadminII error in connecting to PostgreSQL Server|
|Previous:||From: Jim Seymour||Date: 2004-06-21 13:26:05|
|Subject: Re: Problem saving some characters|