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 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
