2012/09/30 11:07 -0700, Mark Phillips
The data for this table comes from a web page (charet utf8). I copy/paste word
files into gedit (on linux) and then copy/paste from gedit to a text boxes on
the web page input form. I had thought I was stripping out all the funky
characters by usin
f8/other.
> > * The problem is on ingestion / on retrieval.
> >
> > The thing mentioned involved 2 steps:
> > ALTER TABLE ... MODIFY COLUMN BINARY (or BLOB); -- to forget any
> > charset knowledge ALTER TABLE ... MODIFY COLUMN CHARACTER SET ...;
> > -- com
COLUMN BINARY (or BLOB); -- to forget any charset
> knowledge
> ALTER TABLE ... MODIFY COLUMN CHARACTER SET ...; -- coming from BINARY,
> this does not check the encoding.
> (sorry, don't have the link handy)
>
> > -Original Message-----
> > From: h...@tb
the encoding.
(sorry, don't have the link handy)
> -Original Message-
> From: h...@tbbs.net [mailto:h...@tbbs.net]
> Sent: Thursday, September 27, 2012 2:24 PM
> To: Mark Phillips
> Cc: Mysql List
> Subject: Re: Need Help Converting Character Sets
>
> >>&
essage-
>> From: Mark Phillips [mailto:m...@phillipsmarketing.biz]
>> Sent: Monday, September 24, 2012 4:28 PM
>> To: Mysql List
>> Subject: Need Help Converting Character Sets
>>
>> I have a table, Articles, of news articles (in English) with three text
&
2012/09/24 16:28 -0700, Mark Phillips
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 characte
eclared for the column they go in. (Presumably, all the text columns will be
declared utf8 or utf8mb4.)
> -Original Message-
> From: Mark Phillips [mailto:m...@phillipsmarketing.biz]
> Sent: Monday, September 24, 2012 4:28 PM
> To: Mysql List
> Subject: Need Help Convertin
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
