List:General Discussion« Previous MessageNext Message »
From:zzapper Date:February 10 2005 12:35pm
Subject:Re: Filtering non-ascii characters from mysql data, null, tab etc
View as plain text  
On Thu, 10 Feb 2005 10:17:00 +0000,  wrote:

>Hi,
>I've successfully used the following update-replace statement to replace strings in
> mysql data
>
>update tbl_county_lookup set countyname=replace(countyname,'&','and') ;
>
>However I've had problems trying to replace a null character 0x00h , 
>
>I'd be interested to know the syntax to filter null characters.
>
>Secondly I'd be interested in a general filter for non-ascii.
>
>cheers
Can't believe I'm the only one who's ever had this problem, I've googled and just found a
few fellow
searchers!!

(I will probably have to dump the db and use a perl script!)

zzapper (vim, cygwin, wiki & zsh)
--

vim -c ":%s%s*%CyrnfrTfcbafbeROenzSZbbyranne%|:%s)[R-T]) )Ig|:norm G1VGg?"

http://www.vim.org/tips/tip.php?tip_id=305  Best of Vim Tips

Thread
Filtering non-ascii characters from mysql data, null, tab etczzapper10 Feb
  • Re: Filtering non-ascii characters from mysql data, null, tab etczzapper10 Feb
    • Re: Filtering non-ascii characters from mysql data, null, tab etcThomas Spahni11 Feb
    • Re: Filtering non-ascii characters from mysql data, null, tab etczzapper11 Feb
    • Re: Filtering non-ascii characters from mysql data, null, tab etczzapper11 Feb
      • Re: Filtering non-ascii characters from mysql data, null, tab etcMichael Stassen12 Feb
    • Re: Filtering non-ascii characters from mysql data, null, tab etczzapper13 Feb