From: Raman <ramang@smartdatainc.com>
To: pgsql-sql@postgresql.org
Subject: Invalid Characters
Date: Mon, 15 Mar 2004 16:07:16 +0530
Message-ID: <00ec01c40a79$7ec4be00$d4c7a8c0@raman> (raw)
Hi All,
I have imported some data from csv files in my DB. Now that data has some invalid characters stored in it.
so I get this exception:
Exception in ChannelDAO Invalid character data was found. This is most likely caused by stored data containing characters that are invalid for the character set
the database was created in. The most common example of this is storing 8bit data in a SQL_ASCII database.
Now, I tried using to_ascii() fn in my select query but it didn't work. Cn you please suggest any solution so that invalid characters should not come to my webpage while displaying.
Regards
Raman Garg
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ramang@smartdatainc.com
Subject: Re: Invalid Characters
In-Reply-To: <00ec01c40a79$7ec4be00$d4c7a8c0@raman>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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