Hi All,
Problem Statement:
I have a field with BLOB data type in DB2 database, I want to extract this blob and convert it to Text. The text data after the conversion will be in Japanese characters. How can I write a select with the conversion from Blob to Text and have the proper conversion from BLOB to Japanese Text.
Any quick help is highly appreciated.

Views: 89

Reply to This

Replies to This Discussion

Hi All,
I have been working on this requirement and could manage to convert blob to hexadecimal and when I convert the hexadecimal value to text on online converters (from hexadecimal to string) its giving me the desired results.
Now, could anyone please help in converting hexadecimal to string/ text at the query level or through any script?

Thanks in advance.
I finally managed to convert the blob into text (Japanese Characters). Below are step I could figure out:
1. Convert to BLOB to Hexadecimal. Simple conversion can be done at SQL query level.
2. Once you have the hexadecimal values, you can write a xxd command on unix to convert it to text.



Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.


Introducing IBM Db2 for z/OS Developer Extension for Microsoft Visual Studio Code

Started by Calene Janacek in Application Development and DB2 on Thursday. 0 Replies

We are excited to announce that the first iteration of IBM Db2 for z/OS Developer Extension is available now as a free downloadable extension in the…Continue

QMF Governor

Started by Maitena Gallastegi Ginea in Application Development and DB2. Last reply by Maitena Gallastegi Ginea on Thursday. 4 Replies

Hi,We are using QMF Governor to limit the QMF queries of users.We have configured correctly and it is working OK. We want to get statistics of those queries canceled by QMF Governor but we are not able to discover where that information is stored.…Continue

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service