asp displaying long raw field

6 Mar 2005 2:22 PM

bob

Hi All,

I have an Oracle database which has a field LONG RAW type to store text
files. I'm trying to display the output of this field in ASP but I'm having
problems.

I've gone through many different approaches but they either do nothing or
do
the following;

I've tried doing response.binarywrite(rs("data_object")) and I get
something
like below

?<?S¿O?A?~·Ç?¸?ä?R~?m$!»?Ä?!S?Z ?÷Ð?#Å1ì
{ »3ëÌÛc-4Úhac±ÑhaIâß`¬5±ÔÊØ[Û:»ìý@*d6ïÍ{ûÍ÷¾÷æè?ä¤?«6÷u?Tx.s"íSaSý?óºDnï+Kìïzü@'6ºM??è¥Ô0Ù._
.
?úM®AÁ"!Ò?1Ë&OûTJâÐSàþ??M×¦U^§&oM?>¼ëØ,?-?!VI?(.?£Ö?i?#D×3îP?¹X´`¤?³io'N¢G~cl
P?«Ä3;'´ûð?4 z?ñij1?aé?i?0Öuí*' ÅGÁ
ò?;äb?O?¹??_ÆNÖ,,<®euA?@¦µ?Å³zJ?"áê_Z?ª+#1?=¦ §?r½ß?~?ßþs??y"z.Ä'~Ð
Aef{õ(Xº?ñê;èSß,Ú9"ìÌÂ\?2ÖH7?R?SÑYïÞÿ~òl^fO ¹&ñB?
?îä.þ??O^N??<×'Sú?ÈÙ¤ì¼ò³?Zq¡í^LÂÅ¶¯©ðlW8';'òZ?ûíÕÃÇ<?2?dM?±I@ì¤%¶

>ehÂõ?kT? · ºe,Dul«knîì)ÈÅ"j¼´P´?Z«J?^|¹ûvXNy²òS×ü???t?>_YïyóúÆ¶â?

êO²zm×#Z?C'? ¥fs¥z"éè !??Å?§S?Â?ãxÉ¸%¸Æ".Ï¨?×«-{®*×X¥¤N.4J^ÄnÄ
Ô?E&¯MÎL!ô-WÖCÎ$jYWh-ÿ © T Ò.özs® ªND??ér¦ÞÎDJ`º~O?¦g.U)Ý¶6§ç""sej»qò
s\FÓ'ÿ?^öbäO?

The data type is adLongVarBinary and ive seen some sites suggest binary to
multibyte but I have no idea how to do that or if its on the write lines.
Does anyone have any ideas?

Many many many thanks in advance :o)
Bob

6 Mar 2005 5:55 PM

Bob Barrows [MVP]

bob wrote:
Show quote

> Hi All,
>
> I have an Oracle database which has a field LONG RAW type to store
> text files. I'm trying to display the output of this field in ASP but I'm
> having problems.
>
> I've gone through many different approaches but they either do
> nothing or do
> the following;
>
> I've tried doing response.binarywrite(rs("data_object")) and I get
> something
> like below
>
>

it's not about Oracle, but does this thread help?
http://groups-beta.google.com/group/microsoft.public.inetserver.asp.db/browse_frm/thread/b048727d574c311f/182f471419b18654?q=accessing+binary+(blob)+data+from+SQL+server#182f471419b18654

This also may help, despite its applying to SQL Server:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q258038
..
This seems more relevant:
http://support.microsoft.com/kb/185958/EN-US/

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"