Re: Removing space characters ... char(160)? ... char(194)?

Hi all. I'm trying to weed out garbage that comes from copying and pasting stuff from a web page. Some of the data has spaces, but a *different* kind of space ... a char(160) kind ... I think ... I figured this out by copying the space character and pasting it into mysql thus: select

RE: Removing space characters ... char(160)? ... char(194)?

Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: Amer Neely [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 13, 2007 3:53 AM To: mysql@lists.mysql.com Subject: Re: Removing space characters ... char(160)? ... char(194)? Hi all

Removing space characters ... char(160)? ... char(194)?

Hi all. I'm trying to weed out garbage that comes from copying and pasting stuff from a web page. Some of the data has spaces, but a *different* kind of space ... a char(160) kind ... I think ... I figured this out by copying the space character and pasting it into mysql thus: select