How to convert blob data to string in db2. In DB2...
How to convert blob data to string in db2. In DB2, CLOB (Character Large Object) is a data type used to store large amounts of character - based data, such as long text documents, XML data, or any other How would you decode a hex string to get the value in text format by using a select statement? For example my data in hex is: We are implementing a file upload and storage field in our DB2 database. BLOB strings are not associated I want to insert a PNG image in DB2. The source type is used for user-defined distinct types. I have used the below cast function for this query: select cast (BLOB Column as Binary) from Table_Name. The expected result is just a s Define a connection between a . The maximum length of the DB2 character and How would you decode a hex string to get the value in text format by using a select statement? For example my data in hex is: How to convert BLOB data (ex: 136948a98e67) retrieved from DB2 into JSON format/String using java Asked 3 years, 2 months ago Modified 3 years, 2 months ago Viewed 879 times I have a DB2 (9. To convert a String to a Blob, use the connection's createBlob () method and write the String A string is a sequence of bytes that can represent characters. To access LOBs in S/390 DB2, additional auxilaiary // tables and indexes need to be created on server side. DB2 BLOB to CLOB is more than a data type conversion; it’s about preserving XML structure while moving data between storage formats. I tried to cast the blob to a varchar, which In some instances, you might find it necessary to convert BLOB data into TEXT data. Here we discuss how we can convert the value of one data type to another with the help of the CAST() function. For documentation manipulation, it relies on Db2 NoSQL JSON APIs. Character string literals up to 254 bytes in length have a data type of CHAR. csv of del lobs to ‘D:LOAD’ MODIFIED BY LOBSINFILE SELECT * FROM TBL_TEMPLATE2” I get “lobexp1. In this guide, I will show you how to retrieve and convert BLOB data into text using MySQL The Import Column transformation streams file binaries – the contents of a file – into a binary large object (Blob) “column” in a Data Flow Path. If you use this method to retrieve data from a DB2Blob instance, you cannot use the Value property or the GetBytes method to The BLOB function returns a BLOB representation of a string of any type or of a row ID type. E. Introduction In this article, we’ll see how we can serialize and deserialize java. MORE: If the data was originally in utf8 (from whatever source it was received, then written into the blob), utf16 will not do what you want - you A binary string is a sequence of bytes. I would like to convert the field to varchar2. NET Client driver throwing conversion error as “System. I used this SQL to create a function. But it is Free BLOB converter - securely convert BLOB files to STRING, IMAGE, MP4, TEXT, FILE or Notepad online. The java. ResultSet. Db2 ODBC manages the transfer and any required conversion of data between the application and the database server. Hibernate extends that to enable performance optimizations. 1 and higher for Linux/UNIX/Windows, the DB2 data provider supports the XML data type. Within a string, all the characters are represented by a common encoding representation. A BLOB is designed to store non-traditional data such as pictures, I am stuck into a situation where I need to insert data into a blob column by reading a file from the Filesystem in DB2 (DB2 Express C on Windows 7). However, a number of SQL data types are compatible. CAST_TO_VARCHAR2 (DBMS_LOB. By default, the data provider maps the XML data type to the . Another approach is to use a PL/SQL procedure to read the BLOB data and return the Is there anyway to figure out what character set the BLOB field is using so that I can convert it to text properly? Any help with this problem will be much appreciated. When you do assignments or comparisons of data that In this article, we would be learning a SQL query to convert a column of BLOB Data Type to VARCHAR Data Type. Hi All,Anyone please let me know how to convert BLOB data that we are pulling from a oracle table into a xml file or data. My approach here is to create a new column with CLOB type, copy all the data from BLOB column to CLOB Guide to PostgreSQL blob. This section introduces you to the Db2 string functions that help you manipulate character string data effectively. , the DB2 data type to use when extracting the JSON data). Now I'd like to get approximately 20 characters from the beginning of the xml. converttoclob function to convert a BLOB to a CLOB and access the text data directly. Byte Array data into text for a column in my table. Step 3: Creating a Database and Table Before proceeding with the image conversion, create a MySQL database and a table to store the image data. Finally, we call readAsText with blob b to read the blob into a string. From the Data Flow BLOB : Variable-length binary large object string that can be up to 2GB (2,147,483,647) long. Binary strings are not associated with any CCSID. If I do the following: Select CAST(JSONBLOB as VARCHAR(2000)) from MyTable --> this returns the It accepts three arguments: a BLOB (BSON) column or variable, a path to the desired element, and a result data type (i. Convert XMLNSC to BLOB Sometimes you may need to convert your payload to a BLOB (B inary L arge Ob ject). in Casting between data types, we can see when taking BLOB or BINARY as This method can only be used to retrieve data from a DB2Blob instance once. This method is the recommended ESQL Code Snippets 1. I have declared a DB2 table with a column of data type BINARY (DB2 v 9. Db : Db2 on Ibm I want to extract original files stored as BLOB in DB2 database. Primarily intended to hold non-traditional data, such as voice or mixed media. When you insert the data into an XML column, it must be converted to its XML hierarchical format. 2013. Blob using Jackson. The length of a binary string is the number of bytes in the sequence. Hi Developers, I'd like to convert blob data to string and convert to string data to blob. Blob represents a Binary Large I am new to app connect and esql. Here we discuss the introduction to PostgreSQL blob, how blob data type works with respective query examples. Spring Data does not handle BLOBs but Spring Content does. Learn how and when to use both options. MYTABLE ( REC_ID FOR The string representation of an XML document in the example is converted to BLOB to reproduce your XML_DATA column contents. e TINYBLOB, BLOB, MEDIUMBLOB, and Does anyone have any idea to how to convert a db2 blob to character/string using java transformation. They are binary large objects (BLOBs), character large objects (CLOBs), and double-byte character large objects (DBCLOBs). So I tried the sql below, but the 3rd parameter of the dms_lob. In a Unicode database, if a supplied argument is a graphic string, it is first converted to a character string data type before the function is executed. Use You can store and retrieve JSON data directly by using SQL with several built-in and user-defined functions that are supplied with Db2 Accessories Suite for z/OS. Theory of BLOB storage in DB2 Introduction : In real world we have structured data and unstructured data. Do not use HEX or My solution is: (1) create a new column, named "MESSAGE_CLOB" (2) convert the bytes in "MESSAGE" (the existing BLOB column) to a string in the charset which is used when inserti Learn how to efficiently convert DB2 BLOB data containing hexadecimal or text representations to ASCII. LOBFILE lob SELECT BLOB_COL FROM MY_TABLE where Returns a string that represents the DB2Blob structure. It connects to all popular databases and runs on Win, macOS & Linux. e TINYBLOB, BLOB, MEDIUMBLOB, and My problem that I have is a system stores text data in a blob field and I want to use a select statement to see what the text data is in the blob field. Db2 for i supports three data types for large objects. DEL OF DEL LOBS TO . In this guide, we explore reliable patterns, DB2 functions, and You can also use the dbms_lob. JSON data is stored internally as I have a BLOB field in a table that I am selecting. The names of the functions and their purpose are In DB2, BLOB (Binary Large Object) is a data type used to store large amounts of binary data, such as images, audio files, video files, and other unstructured DB2: Hi. LOBFILE lob SELECT BLOB_COL FROM MY_TABLE where This example will convert the data in BLOB_column to the type varchar2. I am able to insert image in my SQL using Load File function. Is there an easy way to do this? The only way I can think to do Oracle Database provides a number of built-in data types as well as several categories for user-defined types that can be used as data types. For DB2 V9. FYI: Source is a blob, SQ is binary and target is a varchar datatype. 5 TB of files (90 kb avg) stored as varbinary How do I convert BlobColumn to String in SSIS Script Component. I donot know how to do that, is there a way to do this. – SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, SQL queries and SQL scripts from IBM DB2 to Microsoft SQL Server (MSSQL, The schema is SYSIBM. However, not all data conversions are supported. Binary large objects (BLOBs) Use The supported casts between built-in data types are shown in Table 1. NET String data type, but you can When Db2 implicitly casts a character string or graphic string value to a numeric value, the target type is DECFLOAT (34) which is compatible with other numeric data types. It means, that my final big string have more than 32K symbols (we use 1byte character set - CL8MSWIN1251). XML parsing is the process of converting XML data from its serialized string format to its hierarchical format. getBytes() method or set using setBytes() method. This guide will walk you through efficient methods for handling Using TDI/SDI, a blob will be returned as a byte array. The date - 841002 Double-byte character large objects (DBCLOBs) Use the DBCLOB data type to store large amounts of DBCS data, such as documents that use a DBCS character set. One of my reports need to get data from an DB2 database, which i am able to successfully connect. In IBM DB2, you might encounter hexadecimal data that you want to convert or cast into a readable string. parse to convert the parsed JSON blob string to an object. If you are on DB2 iSeries and know RPG you can use the code that I posted here in November. A 1 I have a db2 table with a blob column which contains gzipped xml data. To be able to accomplish this the ASBITSTREAM function has to Db2 supports several types of string data: character strings, graphic strings, and binary strings. How can I convert this in binary data in utf-8 I have a variable OBJECT_ID stored in DB2 as OBJECT_ID VARCHAR() FOR BIT DATA NOT NULL. specifies a varying-length column for character string data. You cannot cast a BLOB to a string by DB2 SQL directly, at least unable to do it now by the CAST function. This is an example of using Db2 for IBM i BLOB data type with ODBC. I want to know the number of characters that my BLOB column has. If the target type is one of the character or graphic string types, the resulting XML value is converted, if necessary, to the CCSID of the target data type using the rules described in "Conversion rules for For example, when reading a table with a variable character string of length greater than 254 bytes, the ODBC Driver for DB2 returns a LONG VARCHAR. DbVisualizer is the SQL Client and Database Tool with the highest user satisfaction. This method can only be used to retrieve data from a DB2Blob instance once. So, I was going to try to split the string into 3 parts, then combine the string in PeopleCode. For Postgres which data type I have to use instead of blob in Copy Hibernate will map the data in the database to the Java object using the same mapping information on the annotations. net Forum Index » WebSphere Message Broker (ACE) Support » It means, that my final big string have more than 32K symbols (we use 1byte character set - CL8MSWIN1251). I want to convert a string json and blob to json object. The syntax of IBM DB2 to PostgreSQL Migration SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from IBM DB2 to Introduction Binary Large Objects (BLOB) data can be a graphical image, a pdf document, a music file or any of a wide range of data types, which can generally be saved into a SQL Server database. If I am stuck into a situation where I need to insert data into a blob column by reading a file from the Filesystem in DB2 (DB2 Express C on Windows 7). I'm just looking for a simple query to select all the table names for a given schema. It compiled with no errors. I want to insert a PNG image in DB2. (Yes, migrating to and doing the queries from SQL Developer - we are migrating data to Oracle from CAST( MYSTRING AS BLOB CCSID 1208 ) The CCSID parameter is used only for conversions to or from one of the string data types. The JSON data is stored internally as BSON (Binary-encoded Serialization of JSON) in inline BLOB column. 001. x: var str = This method can only be used to retrieve data from a DB2Blob instance once. integer An integer value specifying the length attribute of the resulting BLOB data type. I'm using the code below. io. I've used below code for converting String to Blob: BLOB A binary large object (BLOB) is a varying-length string with a maximum length of 2,147,483,647 bytes (2 gigabytes minus 1 byte). ☁️ Azure Fundamentals (Base Layer) Start with: Microsoft Azure AZ-900 In this tutorial, you will learn how to use the Db2 CONCAT() function to concatenate two strings into a single string. I have a similar problem, wherein i insert the BLOB data into database using the JDBC adapter and while retrieving the BLOB data from the database, i am facing problems while converting the same to I want to extract original files stored as BLOB in DB2 database. 1) table which is defined as follows: CREATE TABLE MY_TABLE ( ID INTEGER DEFAULT 0 NOT NULL, TEXT CLOB(104857600), PRIMARY KEY (ID) ); Now if I want to query the We are implementing a file upload and storage field in our DB2 database. i need to convert it into Binary. Find out everything you need to know about the BLOB data type. Therefore the retrieved User object will The BLOB function returns a BLOB representation of a string of any type or of a row ID type. Right now the file upload column is defined as BLOB(5242880) as follows: CREATE TABLE MYLIB. Any comparisons involving varying-length I have BLOB column and where the XML data is compressed and stored in the table, when I read the data, it shows only some numbers and not actual xml text, How can I convert my DECIMAL(11) field from 12345678 to a character value of 00012345678? Master SQLite BLOB data type with examples. 1). Goto page 1, 2 Next Parsing BLOB to XML « View previous topic :: View next topic » Goto page 1, 2 Next Page 1 of 2 MQSeries. I have a table that have a BLOB data type. Note, that your "converter output" shows incorrect document - there I have lost 2 days to figure out how to migrate XML files stored in DB2 BLOB field using SQL Developer. You can convert the host variable data types to Guide to DB2 CAST. Use Step 3: Creating a Database and Table Before proceeding with the image conversion, create a MySQL database and a table to store the image data. Learn to store and retrieve binary data like images and files in SQLite using Python step-by-step. This article provides a comprehensive guide on how to make that The LOAD utility converts data between compatible data types. I used this DB2 command: EXPORT TO MyFile. Another approach is to use a PL/SQL procedure to read the BLOB data and return the When I export a table with BLOB field using following “db2 export to lobexp1. Find answers to How to convert Clob Datatype to String in DB2 sql from the expert community at Experts Exchange hi all, We are reading the data from remote source table which is having a column of BLOB data type. string-expression A string-expression whose value can be a character string, graphic string, or a binary string. Given that I'd like to perform queries on it using the JSON_VAL function, I always need to use JSON2BSON to The LOAD utility converts data between compatible data types. In some cases, it might be necessary to convert In the first part of this blog, I was looking at how to get your JSON data into Db2. It looks like that because that is how blob data is displayed. If you use this method to retrieve data from a DB2Blob instance, you cannot use the Value property or the GetBytes method to Let's get straight to the point: Converting DB2 BLOB to ASCII isn't always straightforward. If you use this method to retrieve data from a DB2Blob instance, you However, sometimes I need to convert BLOB data into readable text. How can I retrieve the String value stored in it? I have tried following code to convert In this tutorial, you will learn how to use the Db2 SUBSTRING() function to extract a substring from a string, with a specified length. Could you please assist me in converting the BLOB data type into nvarchar , in the BLOB data type I am using the following function to convert binary data to text: public string BinaryToText(byte[] data) { MemoryStream stream = new MemoryStream(data); StreamReader reader = new Stream Then we call JSON. Friends, how can I rewrite my function for using BLOB data type to V_RESULT (2) convert the bytes in "MESSAGE" (the existing BLOB column) to a string in the charset which is used when inserting, and then store the string in MESSAGE_CLOB column for all records in the table Press enter or click to view image in full size Storing Binary Large Object (BLOB) data such as images, documents, audio, and video files is a common You can read BLOB value (binary data) from a table using the getBinaryStream () or, getBlob () methods of the ResultSet interface. Is there an easy way to do this? The only way I can think to do I have a sqlite database from which I want to extract a column of information with the datatype BLOB. InvalidCastException: Unable to cast object of type How to convert data types on DB2 cast functions to convert data type or db2 functions to convert data types On DB2 you have two ways to convert DATA TYPES: We are going to use the table below for I have a table in DB2 with column type BLOB, I would like to convert this to a CLOB type. This field contains only character data. To execute this query we would need to alter the table and subsequently a column's XML data in an application is in its serialized string format. may I get your help to do the above ? let blob_data = LoadBinary( { path : This table shows direct conversions between SQL data types and COBOL data types. File_ID Filename Mime_type created_on blob_content 1 file_new. // // This Introduction Db2 for z/OS supports document storage and manipulation for JSON documents. In this tutorial, you'll learn how to use the Db2 VARCHAR data type to store variable-length character strings. The TO_CLOB function returns a CLOB representation of a string. Both returns a Blob. When fetching BLOB column from IBM i v7r4 database , application using Db2 . Friends, how can I rewrite my function for using BLOB data type to V_RESULT I want to convert SELECT CURRENT DATE FROM sysibm. csv. #Integration-S I am using a Postgresql database in my rails application. e. How can I retrieve the String value stored in it? I have tried following code to convert Binary to String i There are a ton of options on EXPORT – to change the row, column, and string delimiters, to use a fixed-length format or a custom db2 format called IXF that Use a query to get your data from SQL Server into SSIS and use CAST in the query to get the BLOB into string format DROP TABLE IF EXISTS #Blob; CREATE TABLE #Blob ( SomeBLOB Convert blob to varchar2 I have a table with a blob field. This field data consists only of JSON data. For example, our DB has over 100 tables and I need to find any table that You can also use the dbms_lob. If the application data type is an XML . This guide covers various methods and I need to convert blob (UTF8) i. Want to Batch export DB2 query results BLOB data to files? Try DBBlobEditor, a BLOB/CLOB editor for DB2. [code language="sql"] select UTL_RAW. getBlob(index) or ResultSet. Therefore, the console log should log {test: How should the conversion be done, given that FOR BIT DATA values store binary data (which might include the string-termination character '\0' = 0x00)? You can use BLOB, CLOB, DBCLOB, CHAR, VARCHAR, GRAPHIC, VARGRAPHIC, BINARY, or VARBINARY host variables to update XML columns. There are three binary string Oracle SQL function json_serialize takes JSON data (of any SQL data type, VARCHAR2, CLOB, or BLOB) as input and returns a textual representation of it (as VARCHAR2, CLOB, or BLOB 1. sysdummy1; to 20180119 (YYYYMMDD) rather than with the hyphen 2018-01-19 (YYYY-MM-DD) Mainframe → Azure modernization demos & interviews. MYTABLE ( REC_ID FOR Solved: Hello All, I am new to Qlikview, need help with date conversion. The type "CharacterStreamFromDocument" should only be used for CLOB columns but not for BLOB. Currently i am connecting Qlikview to DB2 database. json application/json 9/1/2020 (BLOB) Now i want to parse this and read the The table which I want to query has a BLOB column that saves characters or photos. lob” which <p> Does anyone have any idea to how to convert a db2 blob to character/string using java transformation. I tried to use the create and parse function like this:SET hi, I’m using sql server 2005 and one of tables holds blob data type that represent our conpany’s Calendar information I would like to be able to convert that field to actual text or string so I can So i am reading an XML file from request note of flow. Once you get a Blob, you can get the byte[] back from the Blob. 🎯 1️⃣ Core Azure Skills for Mainframe Modernization 1. Program will let you convert DB2 data and will then do deletes and inserts into the F00165 for the I am connected to IBM DB2 database with java but data is stored as binary format in database so when I fetch any value it comes as binary or hexdecimal format. If you use this method to retrieve data from a DB2Blob instance, you SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, SQL queries and SQL scripts from IBM DB2 to Microsoft SQL Server (MSSQL, This article educates how to convert Blob to File using JavaScript. The maximum I have a variable OBJECT_ID stored in DB2 as OBJECT_ID VARCHAR() FOR BIT DATA NOT NULL. getBlob(String columnName). But I don't know how to insert image in DB2 column. These methods accept an integer value representing the index of the For example, if you want to compare two columns of different types, such as a user-defined type based on a character and an integer, you can change the character to an integer or the integer to a Db2 10 for z/OS offers document storage support for JSON in Dec. When Db2 implicitly casts a numeric value to a string value, the target type is VARCHAR value which is then compatible with other character string or graphic string data types. This article talks about converting binary data returned as a result of 'char for bit data' attribute on char and varchar fields in db2. TechTip: BLOBs: Don't Run! Embrace Them with RPG!, There's no need to be afraid. Specifically, Spring Content JPA stores content as BLOBs in the database and associates that content with an Entity through annotations. Learn how to convert Db2 database objects to SQL Server database objects in SSMA for Db2. I tried to convert my BLOB into a The following tables summarize the mappings of Java data types to JDBC and database data types for a Db2 on Linux®, UNIX, and Windows systems, Db2 for z/OS®, or IBM® Informix® Db2 ODBC manages the transfer and any required conversion of data between the application and the database server. To accomplish this, DB2 provides functions for manipulating and converting hex data. SUBSTR (BLOB_column, 3200,1)) from The CLOB function returns a CLOB representation of a string. To convert a Blob to a String, read the binary data and decode it using an appropriate character set (like UTF-8). Somewhere on the internet I found this INSERT Db2 JSON Functions There is one built-in Db2 JSON function and a number of other functions that must be registered within Db2 before they can be used. You also need to add a line in the BPML indicating the Path to the Primary Document in the Process I have a DB2 11 database with a large table that has JSON data stored in a CLOB column. Does anyone know how to convert a BLOB (which is RTF format) into a string? I found this code to do it, but it doesn’t work. I want to extract it by an SQL select query, but I have problems converting/casting from BLOB to readable text. It has four types i. NET application and the Db2 database, BLUDB. I have a requirement of converting BLOB to VARCHAR in DB2. JPA provides a simple mapping for LOBs. Usually we refer to the unstructured data When i try inserting a string value in a column in DB2, which is defined as CHAR (15) FOR BIT DATA, i notice that it gets converted into some other format, probably hexadecimal. The expected result is just a s It is working fine but when I'm going to convert String to Blob and trying to insert into database then nothing inserting into database. And need to convert XML data to blob. I am trying this: SELECT cast (data as TEXT) FROM content This is obviously not working. If you want to convert this to a string using the platform encoding, you could do the following, assuming the value is in conn. I wanted to get the value of the BLOB and convert it to Varchar2 or string text readable format. Note: The SAS/ACCESS interface does not support the following DB2 data types: BLOB, CLOB, and DBCLOB. Thanks in Advance,Mouli. Learn different methods such as using the File constructor, Data URLs, and Canvas elements Convert blob to varchar2 I have a table with a blob field. Somewhere on the internet I found this INSERT In this example, Db2 implicitly converted the number 1 to the string ‘1’ and concatenated it with the string ‘2’. The first column represents the data type of the cast operand (source data type), and the data types across the header row (2) convert the bytes in "MESSAGE" (the existing BLOB column) to a string in the charset which is used when inserting, and then store the string in MESSAGE_CLOB column for all records in the table A large object (LOB) is a string data type with a size ranging from 0 bytes to 2 GB (GB equals 1 073 741 824 bytes). How can I convert this in binary data in utf-8 I have table in Db2 which has a column of BLOB dataype. The next bit is what to do with it. Valid values for the Character strings disallow zero octets, and also disallow any other octet values and sequences of octet values that are invalid according to the database's selected The String object is used to represent and manipulate a sequence of characters. sql. * conversion routines. Character string literals longer than 254 bytes have a data type of VARCHAR. I have a db2 table with a blob column which contains gzipped xml data. 5. By default, when you use values of different types in an expression or pass the values of different I have a text string stored as a BLOB data type in a database. substr function isn't picking up the XML serialization is the process of converting XML data from its representation in the XQuery and XPath data model, which is the hierarchical format it has in a Db2 database, to the serialized When Db2 implicitly casts a character string or graphic string value to a numeric value, the target type is DECFLOAT (34) which is compatible with other numeric data types. Learn how to use RPG to load and extract binary data to and from DB2 How should the conversion be done, given that FOR BIT DATA values store binary data (which might include the string-termination character '\0' = 0x00)? In this tutorial, you will learn how to use the Db2 SUBSTRING() function to extract a substring from a string, with a specified length. Learn what BLOB is, why databases have a BLOB data type, and what types of data it can store. What is the fastest way to export files (blobs) stored in a SQL Server table into a file on the hard drive? I have over 2. BLOB, or Binary Large Object, files are complex data files that store large amounts of binary It is a kind of data type in MySQL that can store files or images in the database in binary format. </p><p> </p><p>FYI: Source is a blob, SQ is binary and target is a varchar The BINARY function returns a BINARY (fixed-length binary string) representation of a string of any type or of a row ID type. G: Source Column : OrganisationProviderID NVARCHAR(MAX) Destination Column : OrganisationProviderID For example, if you want to compare two columns of different types, such as a user-defined type based on a character and an integer, you can change the character to an integer or the integer to a Db2 10 for z/OS offers document storage support for JSON in Dec. To store large file or data in database I have used blob data type in MySql. Use the CCSID parameter to specify the code page of the source // // This sample program shows how to access Blob or Clob fields in // DB2 tables. In DB2, CLOB (Character Large Object) is a data type used to store large amounts of character - based data, such as long text documents, XML data, or any other It is a kind of data type in MySQL that can store files or images in the database in binary format. Want to migrate Large Objects from Db2, Oracle to Azure SQL and Azure Datalake ? Here is the low code / no-code solution. I tried to cast the blob to a varchar, which Given a table with a BLOB column named TOPOGRAPHIC_MAP and a VARCHAR column named MAP_NAME, locate any maps that contain the string 'Pellow Island' and return a single binary string Your data is not stored in hex, its just plain text. The character data that is sent from the database server to the client is converted using Java's built-in character converters, such as the sun. You can convert it to varchar to see it displayed as text. Easy and Fast. I am connected to IBM DB2 database with java but data is stored as binary format in database so when I fetch any value it comes as binary or hexdecimal format. But I am not sure how to Returns a string that represents the DB2Blob structure. awx63, 23khie, lntj, 3rdbl, 0ms4i, mod5, kjdo, kzqes, mvfza, ootzd,