PostgreSQL Handling of Special Characters - Mailing list pgsql-sql

From Christian Paul B. Cosinas
Subject PostgreSQL Handling of Special Characters
Date
Msg-id 001701c64bce$968d59f0$1e21100a@ghwk02002147
Whole thread Raw
In response to Re: Lead and tail quotes with \pset fieldsep  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: PostgreSQL Handling of Special Characters
Re: PostgreSQL Handling of Special Characters
List pgsql-sql
Hi to all,

I am currently using PostgreSQL 8.0.3
My Database uses SQL_ASCII encoding.

I have a program in Visual Basic that connects to PostgreSQL using ODBC
Connection through File DSN.

I insert a text in one fields of my table. 
For example, I insert a special character to that field. 
Let's say a character of 150 ASCII code. Which looks like a hypen.

When I retrieve the value of that field it gives me a question mark
character instead of that  150 ASCII code character.

What could be the possible reason of this?
Is there a setting in the database configuration to understand that such
special characters?

Please..I really need an answer to this..

Thanks You.


I choose Polesoft Lockspam to fight spam, and you?
http://www.polesoft.com/refer.html    



pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Lead and tail quotes with \pset fieldsep
Next
From: "Markus Bertheau"
Date:
Subject: Re: PostgreSQL Handling of Special Characters