Re: 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(_).