| From: | Noah Davis <noahd1(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | bad characters in database |
| Date: | 2004-05-01 21:44:58 |
| Message-ID: | 20040501214458.17250.qmail@web11803.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ryan Riehle | 2004-05-01 22:09:34 | Re: 1 foreign key to 2 different tables? |
| Previous Message | Marc G. Fournier | 2004-05-01 21:27:26 | Re: postgresql.org relay failing? |