From: Paul Thomas <paul@tmsl.demon.co.uk>
To: Raman <ramang@smartdatainc.com>
Cc: pgsql-sql @ postgresql . org <pgsql-sql@postgresql.org>
Subject: Re: Invalid Characters
Date: Mon, 15 Mar 2004 11:42:23 +0000
Message-ID: <20040315114223.A412@bacon> (raw)
In-Reply-To: <00ec01c40a79$7ec4be00$d4c7a8c0@raman>
References: <00ec01c40a79$7ec4be00$d4c7a8c0@raman>
On 15/03/2004 10:37 Raman wrote:
> 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
>
Use UNICODE as the db encoding. You'll have to drop and re-create the db
though.
HTH
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
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: paul@tmsl.demon.co.uk, ramang@smartdatainc.com
Subject: Re: Invalid Characters
In-Reply-To: <20040315114223.A412@bacon>
* 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