Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> inserting a string into a lob

inserting a string into a lob

From: Obistro <obistro_at__at_advalvas.be.remove.this.fake.domain>
Date: Sun, 19 Oct 2003 15:40:26 +0200
Message-ID: <bmu45f$moq$1@news.worldonline.be> 





Hi,



I'm using Oracle 8.1.7 DB.


I want to insert a string (varchar2) into a lob (a long raw in fact).
The string is UTF8 encoded, and I want to know how to convert it from 
varchar2 to long raw, without loosing special characters.
I want to do it internally, ie using a store procedure.



I've found a conversion from char to raw but this only works with ascii 
char.



Could anybody help me ?



Thanks
Received on Sun Oct 19 2003 - 08:40:26 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US