Insert with '

[Mike Yu]

Hi,
How can I insert a string with ' into a table in DB2?

[Jamie Robertson]

Originally posted by Mike Yu:
Hi,
How can I insert a string with ' into a table in DB2?

Use a PreparedStatement ( setString() method ) and it will take care of it for you. If you need to use a statement you have to create a routine that escapes it with the DB2 escape character. Assuming it is 2 single quotes, this routine would work for you:

public String escapeSingleQuotes( String input )
{
   StringBuffer escaped = new StringBuffer();
   for ( int i = 0; i < input.length(); i++ )
   {
      if( input.charAt( i ) == '\'' )  //if needs escaping
      {
         escaped.append( '\'' );  //add an extra escape character
      }
      escaped.append( input.charAt( i ) );  
   }
   return escaped.toString();
}

Jamie