Re: very strange

From: Ed Stevens <nospam_at_noway.nohow>
Date: Fri, 28 Jan 2005 08:22:17 -0600
Message-ID: <n9ikv01t4si4f1s1tjmbalrbtv9f52ngc7@4ax.com>

On Fri, 28 Jan 2005 10:59:32 +0100, inja <no_at_no.spam> wrote:

>Hello,
>
>This request :
>
>.
>update table set varchar_var='oracle=crap i''s sqlserver=bestchoice',
>other='4' where id='1'
>.
>
>does not work.
>
>Looks like a = before a '' crashes the insert/updates.
>
>Any ideas to fix my request ?
>
>Thanks a lot.

Looks like you're not telling us the whole story. Perhaps a bit more detail, including a definition of "does not work".

This from an 8.1.7 db running on Win2k

SQL> desc edstest

 Name                                                  Null?    Type
 ----------------------------------------------------- --------
----------------
--------------------

ID
CHAR(1)
COL1
VARCHAR2(50)
COL2
VARCHAR2(50) SQL> select count(*) from edstest;

COUNT(*)

SQL> insert into edstest values('1','aaa','bbb');

1 row created.

SQL> commit;

Commit complete.

SQL> update edstest set col1='oracle=crap i''s sqlserver=bestcho ice', col2='4' where id='1';

1 row updated.

SQL> commit;

Commit complete.

SQL> select * from edstest;

I COL1

- --------------------------------------------------

COL2

1 oracle=crap i's sqlserver=bestchoice
4

SQL> And given that you're asking help from an *Oracle* ng, perhaps you should leave out the troll-bait.

Thanks.

Ed Stevens

Cohn's Law: The more time you spend in reporting on what you are doing, the less time you have to do anything. Stability is achieved when you spend all your time doing nothing but reporting on the nothing you are doing. Received on Fri Jan 28 2005 - 08:22:17 CST