Invalid Characters - Mailing list pgsql-sql

From Raman
Subject Invalid Characters
Date
Msg-id 00ec01c40a79$7ec4be00$d4c7a8c0@raman
Whole thread Raw
Responses Re: Invalid Characters
List pgsql-sql
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

pgsql-sql by date:

Previous
From: Yasir Malik
Date:
Subject: Object-relational features
Next
From: Paul Thomas
Date:
Subject: Re: Invalid Characters