bad characters in database - Mailing list pgsql-general

From Noah Davis
Subject bad characters in database
Date
Msg-id 20040501214458.17250.qmail@web11803.mail.yahoo.com
Whole thread Raw
List pgsql-general
Was wondering if anyone could help me. I have a
database with some bad characters in it -- some users
had entered MS Word smart quotes, em dashes, foreign
characters, and they look like gibberish coming out of
the database.

What's the best way to replace these characters? I
thought I might be able to run a simple SQL UPDATE
command, but some of the gibberish for different
characters looks the same, and it would clobber them
all.

I have a feeling there's some sort of ASCII code or
unicode solution to this problem, but I could use a
little push in the right direction.

Thanks.

Noah.




__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover

pgsql-general by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: postgresql.org relay failing?
Next
From: "Ryan Riehle"
Date:
Subject: Re: 1 foreign key to 2 different tables?