Re: very strange

inja 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.

Works for me

SQL> create table t (varchar_var varchar2(200), 2 other_col varchar2(1), id varchar2(1)) 3 /

Table created.

SQL> insert into t values (null, null, '1') 2 /

1 row created.

SQL> update t set
2 varchar_var = 'user=crap it''s probably that sqlserver=their limit',
3 other_col = '4'
  4 where id = '1'
  5 /

1 row updated. Received on Fri Jan 28 2005 - 06:52:50 CST