I have a table, Articles, of news articles (in English) with three text columns for the intro, body, and caption. The data came from a web page, and the content was cut and pasted from other sources. I am finding that there are some non utf-8 characters in these three text columns. I would like to (1) convert these text fields to be strict utf-8 and then (2) fix the input page to keep all new submissions utf-8.
91) For the first step, fixing the current database, I tried:
update Articles set body = CONVERT(body USING ASCII);
However, when I checked one of the articles I found an apostrophe had been converted into a question mark. (FWIW, the apostrophe was one of those offending non utf-8 characters):
Before conversion: "I stepped into the observatory?s control room ..."
After conversion: "I stepped into the observatory?s control room..."
Is there a better way to accomplish my first goal, without reading each article and manually making the changes?
(2) For the second goal, insuring that all future articles are utf-8, do I need to change the table structure or the insert query to insure I get the correct utf-8 characters into the database?
Thanks,
Mark
Sep 24
Rick James RE: Need Help Converting Character Sets
Sep 24, 2012; 16:53
Rick James
RE: Need Help Converting Character Sets
Sep 27
hsv Re: Need Help Converting Character Sets
Sep 27, 2012; 17:24
hsv
Re: Need Help Converting Character Sets
Sep 27
Derek Downey Re: Need Help Converting Character Sets
Sep 27, 2012; 21:11
Derek Downey
Re: Need Help Converting Character Sets
Sep 28
Rick James RE: Need Help Converting Character Sets
Sep 28, 2012; 07:59
Rick James
RE: Need Help Converting Character Sets
Sep 30
Mark Phillips Re: Need Help Converting Character Sets
Sep 30, 2012; 11:07
Mark Phillips
Re: Need Help Converting Character Sets
Oct 01
Rick James RE: Need Help Converting Character Sets
Oct 01, 2012; 14:45
Rick James
RE: Need Help Converting Character Sets
Oct 01
hsv Re: Need Help Converting Character Sets
Oct 01, 2012; 22:25
hsv
Re: Need Help Converting Character Sets
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!