|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
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.