473,327 Members | 2,016 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

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
Nov 7 '08 #1
3 5076
"peteh" <ph******@intellicare.comwrote in message
news:21**********************************@r36g2000 prf.googlegroups.com...
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.
Nov 7 '08 #2
Ian
peteh wrote:
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.
Nov 7 '08 #3
On Nov 7, 10:07*am, Ian <ianb...@mobileaudio.comwrote:
peteh wrote:
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.
Bingo! Exactly what I was looking for. Thanks very much to you and to
Mark.

Pete H
Nov 7 '08 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: freak | last post by:
hi i have problems reading an oracle(9i) clob from a php-script with the MDB-class from pear. the table files has 3 fields: id integer document clob picture clob
1
by: Chris | last post by:
I use websphere connection pooling and had a failure attempting a CLOB.createTemporary. tempClob = CLOB.createTemporary(conn, true, CLOB.DURATION_SESSION); Here's an excerpt of the exception...
1
by: Mat Hess | last post by:
We are currently developing a new application. In this application, we have a table which will hold a large number of rows, where many text fields (one text field per row) will be stored. The users...
5
by: gimme_this_gimme_that | last post by:
In Oracle you can have a statement such as insert into foo (foo_id,some_clob) values (100,empty_clob()) where empty_clob() inserts a clob address. What is the approach in DB2 (8.1) to...
3
by: gupta.harika | last post by:
Hi everyone, I am a developer working on php with oracle as backend. I am facing a problem related with the CLOB data. The problem is as follows My application uses a table which contains Clob...
8
by: gimme_this_gimme_that | last post by:
I have the following Java code : package com.rhi.bb.udf.utils; import java.sql.Clob; import java.sql.SQLException; import java.util.regex.Pattern; import java.util.regex.Matcher;
0
by: *Davide* | last post by:
Hello, This query (PHP+Oracle) works: global $user,$pass,$sid; $db_charset = 'UTF8'; $db = OCILogon($user, $pass, $sid, $db_charset); $clob = OCINewDescriptor($db, OCI_D_LOB); $txt_clob =...
0
by: srinivasaraonagisetty | last post by:
hi, I am faceing one problem, while inserting the data in db2 using clob. actually i am writing this type code: public class DBParam { private InputStream inputstream; private static int...
1
by: Veeru71 | last post by:
When I am SELECT'ing a CLOB column from command prompt, the output is getting truncated after a certail limit (8 K ??) How do I get the full data out of a CLOB column? Are there any string...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.