64 bit encoding in CLOB

Hi All;
Platform is DB2 LUW (AIX) v8.2.

I have a vendor package that stores chat transcripts in a CLOB column.
When queried, I see "gobbledegook" that looks like this:
"PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiP z4KPHRyYW5zY3JpcHQ"...
and so on for thousands of characters.

The vendor states that the column is "64bit encoded". Is there a
standard function to "decode" this using column functions? Any help or
similar experience MUCH appreciated.

Pete H

"peteh" <phazzard@intellicare.comwrote in message
news:214e289d-858c-459c-91e9-a7c9c2d7f627@r36g2000prf.googlegroups.com...

Quote:

Hi All;
Platform is DB2 LUW (AIX) v8.2.
>
I have a vendor package that stores chat transcripts in a CLOB column.
When queried, I see "gobbledegook" that looks like this:
"PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiP z4KPHRyYW5zY3JpcHQ"...
and so on for thousands of characters.
>
The vendor states that the column is "64bit encoded". Is there a
standard function to "decode" this using column functions? Any help or
similar experience MUCH appreciated.
>
Pete H

The encoding is some sort of encryption, either done with DB2 encryption, or
done outside of DB2 (in the application) before the data is inserted. You
need to get more information from the vendor on how to decode it.

peteh wrote:

Quote:

Hi All;
Platform is DB2 LUW (AIX) v8.2.
>
I have a vendor package that stores chat transcripts in a CLOB column.
When queried, I see "gobbledegook" that looks like this:
"PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiP z4KPHRyYW5zY3JpcHQ"...
and so on for thousands of characters.
>
The vendor states that the column is "64bit encoded". Is there a
standard function to "decode" this using column functions? Any help or
similar experience MUCH appreciated.

My bet is that they mean "base64" encoded, as in a MIME encoding.

http://en.wikipedia.org/wiki/Base64

There are plenty of tools that can decode this (including perl's
MIME::Base64 routines).

But you should confirm with your vendor.

On Nov 7, 10:07*am, Ian <ianb...@mobileaudio.comwrote:

Quote:

peteh wrote:

Quote:

Hi All;
Platform is DB2 LUW (AIX) v8.2.

>

Quote:

I have a vendor package that stores chat transcripts in a CLOB column.
When queried, I see "gobbledegook" that looks like this:
"PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiP z4KPHRyYW5zY3JpcHQ"....
and so on for thousands of characters.

>

Quote:

The vendor states that the column is "64bit encoded". Is there a
standard function to "decode" this using column functions? Any help or
similar experience MUCH appreciated.

>
My bet is that they mean "base64" encoded, as in a MIME encoding.
>
http://en.wikipedia.org/wiki/Base64
>
There are plenty of tools that can decode this (including perl's
MIME::Base64 routines).
>
But you should confirm with your vendor.

Bingo! Exactly what I was looking for. Thanks very much to you and to
Mark.

Pete H

64 bit encoding in CLOB

re: 64 bit encoding in CLOB

re: 64 bit encoding in CLOB

re: 64 bit encoding in CLOB

Similar DB2 Database bytes

/bytes/development

/bytes/it

/bytes/about