pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Invalid Characters
2+ messages / 2 participants
[nested] [flat]

* Invalid Characters
@ 2004-03-15 10:37 Raman <ramang@smartdatainc.com>
  2004-03-15 11:42 ` Re: Invalid Characters Paul Thomas <paul@tmsl.demon.co.uk>
  0 siblings, 1 reply; 2+ messages in thread

From: Raman @ 2004-03-15 10:37 UTC (permalink / raw)
  To: 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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Invalid Characters
  2004-03-15 10:37 Invalid Characters Raman <ramang@smartdatainc.com>
@ 2004-03-15 11:42 ` Paul Thomas <paul@tmsl.demon.co.uk>
  0 siblings, 0 replies; 2+ messages in thread

From: Paul Thomas @ 2004-03-15 11:42 UTC (permalink / raw)
  To: Raman <ramang@smartdatainc.com>; +Cc: pgsql-sql


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   |
+------------------------------+---------------------------------------------+



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2004-03-15 11:42 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-03-15 10:37 Invalid Characters Raman <ramang@smartdatainc.com>
2004-03-15 11:42 ` Paul Thomas <paul@tmsl.demon.co.uk>

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