asp displaying

[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¿OA~·Ç¸ä?R~m$!»Ä!SZ ÷Ð#Å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ñij1aéi?0Öuí*' ÅGÁ
ò;äb?O¹?_ÆNÖ,,<®e­uA@¦µųzJ"áê_Zª+#1=¦ §r½ß?~ßþs­y"z.Ä'~Ð
Aef{õ(Xºñê;èSß,Ú9"ìÌÂ\2ÖH7R?SÑYïÞÿ~òl^fO ¹&ñB îä­.þO^N<×'SúÈÙ¤ì¼ò³Zq¡í^LÂŶ¯©ðlW8'­;'òZûíÕíÇ<2dM±I@ì¤%¶

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

êO²zm×#ZC'? ¥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 )
Bob

 

[Aaron [SQL Server MVP]]

How about http://support.microsoft.com/?kbid=194799

I also added some words to the subject so that it is more meaningful.

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

<<caron>S¿OA~·Ç¸ä?R~?m$!»Ä!SZ ÷‹#Å1ì
{
»3ëÌÛc-4Úhac™±ÑhaIâß`¬5±ÔÊØ[Û:»ì‡@*<caron>d6ïÍ{ûÍ÷<=÷æèä€?«6÷u?Tx.s"íSaS‡?óºDnï+Kìïz
ü@'6ºMè¥Ô0Ù._
.
úM®AÁ"!Ò1Ë&OûTJâ‹SàflM?œU^§&oM><pi>ëØ,
-!VI(.£Öi#D?3îP’X´`€“io'N¢G~cl

P?«Ä3<caron>;'´û›4 zñij?1aéi?0Öuí*' ÅGÁ
ò;äb?O’?_ÆNÖ,,<®e–uA@œµÅ“zJ"áê_Zª+#1=œ §r?ß?~ßfls–y?"z.Ä'~‹?
Aef{õ(Xºñê;èSß,Ú9"ìÌÂ\2ÖH7R?SÑYïfiÿ~òl^fO ’&ñB

ehÂõkT? · ?ºe,Dul«knîì)ÈÅ"j<pi>´P´Z«J^|’ûvXNy–”òS?ü???t>_Yïyóúƶâ

êO”zm?#ZC'? ¥fs¥z"éè !ŧSÂãxɸ%¸–Æ".Ϩ?«-{®*?X¥€N.4J^ÄnÄ
ÔE&¯MÎL!ô-WÖC?Î$jYWh-ÿ © T Ò.özs® ªND™?érœfiÎ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 )
Bob