Re: Using C# to insert blob into Oracle

From: Chris Fink (chris.fink_at_gmail.com)
Date: 03/15/05 

Date: Tue, 15 Mar 2005 12:44:41 -0500

The string is just text.

"Nicholas Paldino [.NET/C# MVP]" <mvp@spam.guard.caspershouse.com> wrote in
message news:%239u6F9XKFHA.1620@TK2MSFTNGP14.phx.gbl...
> Chris,
>
> It depends on the format of the string. Is it in hex, or is it base64
> encoded, or something else?
>
>
> --
> - Nicholas Paldino [.NET/C# MVP]
> - mvp@spam.guard.caspershouse.com
>
> "Chris Fink" <chris.fink@gmail.com> wrote in message
> news:%23sTII2XKFHA.3512@TK2MSFTNGP15.phx.gbl...
> > How do I convert a C# string into a byte array? Which class do I use,
the
> > StreamReader, StringReader, etc? Any sample code is appreciated!
> >
> > "Nicholas Paldino [.NET/C# MVP]" <mvp@spam.guard.caspershouse.com> wrote
> > in
> > message news:eTasBpXKFHA.3336@TK2MSFTNGP10.phx.gbl...
> >> Chris,
> >>
> >> The provider for Oracle should represent the field as a byte array.
> > You
> >> should be able to assign a new byte array to this field in a data set,
> >> and
> >> then update the field through an ad-hoc query or stored procedure, just
> > like
> >> you would any other value in the database.
> >>
> >> Hope this helps.
> >>
> >>
> >> --
> >> - Nicholas Paldino [.NET/C# MVP]
> >> - mvp@spam.guard.caspershouse.com
> >>
> >> "Chris Fink" <chris.fink@gmail.com> wrote in message
> >> news:OoGdgjXKFHA.3340@TK2MSFTNGP14.phx.gbl...
> >> >I have setup an Oracle table which contains a blob field. How do I
> > insert
> >> > data into this field using C# and ADO.net?
> >> >
> >> >
> >>
> >>
> >
> >
>
>

Relevant Pages

  • Re: Vb 2003 Framework 1.1
    ... >> Ok taking this code below when i look at my LoByte and HiByte ... > If 3595 was a hex number, then the high byte would be hex 35 which ... so i would need to convert the 3595 into this type of format: ... Do you want to convert to a string? ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Date format detection
    ... Specifies the locale for which the date string is to be formatted. ... date format for this locale. ... the system default-date format for the specified locale. ... be enclosed within single quotation marks in the date format picture. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: writing characters using Z edit descriptors
    ... written using Z edit descriptors. ... the string is treated as if it is a single 4-byte integer. ... The VMS DUMP command, which prints a hex and ASCII dump of a file, prints the ASCII values left to right, and hex values right to left so that the hex values agree with normal mathematical notation. ... Consider, though, printing a four character string with Z4 format? ...
    (comp.lang.fortran)
  • Re: Date format detection
    ... > Specifies the locale for which the date string is to be formatted. ... > date format for this locale. ... > the system default-date format for the specified locale. ... > be enclosed within single quotation marks in the date format picture. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Vb 2003 Framework 1.1
    ... i should get a Lobyte as 149 and a hibyte as 53 ... 10 and the low byte is hex B which is 11 base 10. ... so i would need to convert the 3595 into this type of format: ... Do you want to convert to a string? ...
    (microsoft.public.dotnet.languages.vb)