PostgreSQL Handling of Special Characters

From: "Christian Paul B(dot) Cosinas" <cpc(at)cybees(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Cc: "'Christian Paul B(dot) Cosinas'" <cpc(at)cybees(dot)com>
Subject: PostgreSQL Handling of Special Characters
Date: 2006-03-20 03:30:02
Message-ID: 001701c64bce$968d59f0$1e21100a@ghwk02002147
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Markus Bertheau 2006-03-20 04:09:24 Re: PostgreSQL Handling of Special Characters
Previous Message Bruce Momjian 2006-03-20 01:14:55 Re: Lead and tail quotes with \pset fieldsep