Re: Escaping strings?

You are right you don't need to escape the underscore.

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Paul Stead
Sent: Sunday, November 03, 2002 8:07 PM
To: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Escaping strings?


Just curious....

Does Oracle accept escaping a ' with  \'
Or do you have to escape a ' with  ''   in Oracle?

Paul

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org]On Behalf Of Thomas O'Dowd
Sent: Sunday, November 03, 2002 7:32 PM
To: Chris White
Cc: Timothy Reaves; pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Escaping strings?


Hmmm... I had no idea :) Actually, I just had a look at the driver code
behind setString(). It actually looks pretty similar to what I wrote
earlier and doesn't escape the '_' as far as I can see.

         synchronized (sbuf)
         {
            sbuf.setLength(0);
            sbuf.ensureCapacity(x.length());
            int i;

            sbuf.append('\'');
            for (i = 0 ; i < x.length() ; ++i)
            {
               char c = x.charAt(i);
               if (c == '\\' || c == '\'')
                  sbuf.append((char)'\\');
               sbuf.append(c);
            }
            sbuf.append('\'');
            bind(parameterIndex, sbuf.toString(), type);
         }

Does the '_' need to be escaped? Why? If so, the driver code should be
updated I guess.

Tom.

On Mon, 2002-11-04 at 12:10, Chris White wrote:
> I think you also have to escape underscore(_).



---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org