title: How to insert result of mysql_real_escape_string() into oracle database?
body: <p>For inserting special characters in data like (,')etc., I am using mysql_real_escape_string() function &amp; it's working fine.</p>
  
  <p>Now I want to use same variable while inserting values in Oracle.</p>
  
  <pre><code>$str = 'N.G.Palace\'s Building',
      'xyzcity', '12345678','India','100001',12
  </code></pre>
  
  <p>Here $str is result of mysql_real_escape_string(). so it escapes special character.
  Now my code for oracle is like this-:</p>
  
  <pre><code> $qry ="INSERT INTO Ora_table(ship_to_street, ship_to_city,ship_to_country, ship_to_telephone, order_id, record_no) VALUES(".$str);
  </code></pre>
  
  <p>So my doubt is Oracle is not accepting values return by mysql_real_escape_string i.e. Palace\'s (like this as this mysql function attach \ before 'single quote)?
  So can anybody tell me ho9w can I use that variable $str to insert data into Oracle?</p>
  
  <p>Also I tried like this also-:</p>
  
  <pre><code>"q"."'"."c".$str."c"."'"
  </code></pre>
  
  <p>can we use this for multiple values like in my case...though still I am unable
  to inser data in oracle?</p>
  
  <pre><code>HOW to insert special characters in Oracle db?
  like 'SWEET/HOME', 'CROY-BOY' etc. /,-,\ etc.
  </code></pre>
  
  <p>please tell me..</p>