It is possible that one had /r/n and the other just /n. I was doing the
comparison using psql.
The issue was not using LIKE and %.
I resolved the problem by removing chr(13) from both sides. So my
working query was had a where clause like this:
WHERE REPLACE(message, chr(13), '') = REPLACE('', c
You have made a wrong mistake in your SQL quary.
Your quary should be look like this.
SELECT id FROM table1 WHERE message like '%VAC153-683-685-131830-
/O.NEW.KLWX.SV.W.0022.060413T1742Z-060413T1830Z/
BULLETIN - EAS ACTIVATION REQUESTED
SEVERE THUNDERSTORM WARNING
NATIONAL WEATHER SERVICE
On 13 Apr 2006 12:20:08 -0700, Nik <[EMAIL PROTECTED]> wrote:
> I am trying to compare a large string (that has new line characters in
> it) to the contents of the text field (which also has new line
> characters in it) and it is not behaving as expected.
>
> For example I have the following record
I am trying to compare a large string (that has new line characters in
it) to the contents of the text field (which also has new line
characters in it) and it is not behaving as expected.
For example I have the following record in the database:
id=83
message=VAC153-683-685-131830-
/O.NEW.KLWX.SV.W
