Run SQL Scripts - unreadable characters as hexadecimal

Run SQL Scripts - unreadable characters as hexadecimal

Here, In this article we will discuss about the most common issue that we all usually face is we see unreadable character to be displayed for character columns defined with CCSID 65535 that look alike hexadecimal when we query using Run SQL Scripts within ACS(Access Client Solutions).

Running the query from Run SQL Scripts to display the character column having ccsid 65535 data in unreadable hexadecimal characters.

Suppose, we created table TESTPF using below CREATE TABLE syntax where character field FLD1 defined with ccsid 65535 and FLD2 defined with ccsid 37.

CREATE TABLE EASYCLASS1/TESTPF (FLD1 CHAR ( 10) CCSID 65535 NOT    
NULL WITH DEFAULT, FLD2 CHAR ( 10) CCSID 37 NOT NULL WITH DEFAULT) 

We inserted same data in both the columns FLD1 and FLD2 using below SQL Insert query

INSERT INTO EASYCLASS1/TESTPF VALUES('test', 'test')   

Now, when we do SELECT on EASYCLASS1/TESTPF from Run SQL Scripts , we face this issue

select * from  easyclass1.testpf;

Steps to resolve this issue

Within Run SQL Scripts, Select Edit and then JDBC Configurations.

Select JDBC configuration to change and then select Edit on the right side.

Under the Translation Tab, Select Translate CCSID 65535 and then Save.

Restart Run SQL Scripts.(Goto Connection Tab then Connected then Apply JDBC Configuration and name of the JDBC configuration you change in previous steps

Note:

We can also do the same using (Goto Connection Tab then Connected then Edit JDBC Configuration then under Translation Tab select Translate CCSID 65535 and then Save and then reconnect and apply JDBC configuration.

After, changing the settings using the above steps, the correct data got displayed using Run SQL scripts for character column defined with ccsid 65535.