Hmm maybe "x7" could indicate it's base15? They used to store ascii in that
encoding, because it's "shorter" then 8 bits (base16)... Nope, it's not that,
and it'd be (number)x or something like that anyway... fumbling around... what
if there's a 0 missing at the start (0x is used for octal, base16, 8 bit)? Of
course!
So what I did was encode the base16 codes to numbers and then chars, in a
repeat loop (ignoring the x) and in the end i got: "{\rtf1\ansi\a" So that
looks about right.
Here's the code:
--
on mouseUp
put "x7b5c727466315c616e73695c616" into theData
repeat for each char theChar in char 2 to -1 of theData
put theChar after twoChars
if the length of twoChars = 2 then
put baseconvert(twoChars,16,10) into twoChars
put numtochar(twoChars) after theResult
put "" into twoChars
end if
end repeat
put theResult -- {\rtf1\ansi\a
end mouseUp
--
cheers
Björnke
On 21.05.2013, at 04:11, Jose Damaso wrote:
> Hi - a legacy database at work contains a bytea field that I want to get
> the information out of. It's rich text that was for whatever reason, was
> stored as a blob to keep the formatting codes intact -- I'm not even sure
> what that means since no one here knows much about it and there is no
> documentation on the system. Does anyone know how to convert the returned
> query contents of this bytea field to text (or richtext?) with livecode? It
> looks like this
>
> x7b5c727466315c616e73695c616... etc.
> when my basic query is
> put "SELECT c.reportnumber, c.reportblob from cases c WHERE c.ID = " &
> tCaseID into tQuery
>
> Thanks!
>
> I'm a layer2 guy at work but am planning to use Livecode as my programming
> gateway drug =)
--
Use an alternative Dictionary viewer:
http://bjoernke.com/bvgdocu/
Chat with other RunRev developers:
http://bjoernke.com/chatrev/
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
