Re: Saving Rich Text Format (RTF) in Oracle 10g using PL/SQL via VB/ASP.NET

From: Terry Dykstra <>
Date: Thu, 22 Jan 2009 00:26:38 GMT
Message-ID: <23Pdl.6092$PH1.3271_at_edtnps82>

"George Lewycky" <> wrote in message
> Hi Everyone,
> I am converting from a Filemaker application to VB.NET/Oracle and the
> question that the user has a TEXT BOX where the user is able to
> highlight, color, underline, etc. the text.
> What I am seeing is RTF is the best option for VB/ASP.NET but where I
> am stuck is how to save/retrieve/update the RTF text in Oracle and/or
> translating it back to VB ?
> If anyone has any experience, ideas for this I'd really appreciate
> hearing from you
> Sincerely
> George Lewycky
> NY City Transit

rtf is just text, so you can use a varchar2 column, although a clob is probably a better choice. Your grid control or whatever you use in your application needs to be rtf aware.

Terry Dykstra 
Received on Wed Jan 21 2009 - 18:26:38 CST

Original text of this message