Charset Encoding Problem in DatabaseReader

I am using a database reader connector to transform coming data. But coming data in result has undefined characters. I am aware that is an encoding problem.But I dont know how to fix the problem.



My Database char set : ISO8859



My Query

var dbConn;

try {

dbConn = DatabaseConnectionFactory.createDatabaseConnection ('oracle.jdbc.driver.OracleDriver','jdbc:oracle:th in:@192.168.62.100:1521:PRSD','***','***');

var sql = "SELECT * FROM IHE_PACS_VIEW p " +

"WHERE p.PACS_SEND_STATUS = 0 "+ //Procedure scheduled

"OR p.PACS_SEND_STATUS = 2"; //Procedure updated

var result = dbConn.executeCachedQuery(sql);

return result;

} finally {

if (dbConn) {

logger.info('kapandı');

dbConn.close();

}

}



Result



<result>

<accession_number>45919</accession_number>

<req_proc_is_cancelled>0</req_proc_is_cancelled>

<patient_pk>14052</patient_pk>

<entered_by>baskan^ÜNSAL^GÖKHAN</entered_by>

<assigned_patient_location>^^^^</assigned_patient_location>

<filler_order_number>35920</filler_order_number>

<alternate_patient_id>40979033128</alternate_patient_id>

<priority>R</priority>

<ambulatory_status>A0</ambulatory_status>

<sps_status>SC</sps_status>

<station_name>SIMENS-CT</station_name>

<mobile_tel_hl7>()-</mobile_tel_hl7>

<station_ae_title>Aee</station_ae_title>

<request_date>2014-10-23 12:06:57.464</request_date>

<todatetime>201410251632</todatetime>

<date_of_birth>19470913</date_of_birth>

<visit_number>498962</visit_number>

<sex>F</sex>

<home_tel>3120000000</home_tel>

<code_value>905320</code_value>

<social_healthcare>^</social_healthcare>

<paid>1</paid>

<req_proc_status>PE</req_proc_status>

<pacs_send_status>0</pacs_send_status>

<home_tel_hl7>(312)000-0000</home_tel_hl7>

<healthcare>20579^SGK BAŞKANLIĞI HUKUK MÜŞAVİRLİĞİ</healthcare>

<code_meaning>Protrombin zamanı (koagülometre)</code_meaning>

<sps_start_time>201410230725</sps_start_time>

<patient_class>O</patient_class>

<patient_name>ÖZTEL^REFİGÜL</patient_name>

<diagnostic_service_his>5300^Radyoloji MR-BT-US</diagnostic_service_his>

<entering_organization_his>5280^Dahiliye PolikliniÄŸi Kas</entering_organization_his>

<placer_order_number>9781</placer_order_number>

<req_proc_pk>35920</req_proc_pk>

<modality_type>CT</modality_type>

<study_instance_uid>1.2.826.0.1.3680043.8.165.4591 9.20141023</study_instance_uid>

<address>^^^</address>

<sps_pk>17851</sps_pk>

<order_control>NW</order_control>

<patient_id>488024</patient_id>

</result>



How can I change char set of Database Reader? or another way??

Thank for help

Charset Encoding Problem in DatabaseReader