Re: REGEXP_REPLACE woes

On Tuesday 10. June 2008, Michael Fuhr wrote:

>Something between my message and your shell appears to have converted
>a few spaces to no-break spaces. A hex dump of your query shows the
>following:
>
>00000000 73 65 6c 65 63 74 20 72 65 67 65 78 70 5f 72 65 |select
> regexp_re| 00000010 70 6c 61 63 65 28 0a c2 a0 20 c2 a0 27 5b 70 3d
> |place(.   '[p=|
>
>Notice the byte sequences "c2 a0", which is the UTF-8 encoding of
><U+00A0 NO-BREAK SPACE>. Apparently psql doesn't like that. I don't
>see that sequence in my original message:

It's probably a KMail bug, or more likely a Qt or KDE library bug. IIRC
there was a similar bug in KNode some years ago when i tried to copy
and paste some Python code from a news discussion.
--
Leif Biberg Kristensen | Registered Linux User #338009
http://solumslekt.org/ | Cruising with Gentoo/KDE
My Jazz Jukebox: http://www.last.fm/user/leifbk/