topic Re: How to convert EBCDIC character set data using qlik view sql load in App Development https://community.qlik.com/t5/App-Development/How-to-convert-EBCDIC-character-set-data-using-qlik-view-sql/m-p/122328#M8511 <HTML><HEAD></HEAD><BODY><P>I don't recommend doing your own conversion character by character - even with a map.</P><P></P><P>First of all - all ODBC / OLEDB drivers on Windows that support your SQL database can do the conversion for you. EBCDIC is an extended familiy of character sets - not just one. Just like the ASCII/ANSI is ...</P><P></P><P>So be sure to identify which <STRONG>EBCDIC code page</STRONG> your database is set to. Then go into the ODBC-driver and find the conversion options there to specify the source EBCDIC code page and then you should get a Windows readable character set.</P></BODY></HTML> Sun, 26 Aug 2018 16:26:02 GMT petter 2018-08-26T16:26:02Z How to convert EBCDIC character set data using qlik view sql load https://community.qlik.com/t5/App-Development/How-to-convert-EBCDIC-character-set-data-using-qlik-view-sql/m-p/122327#M8510 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>can anyone help me with the logic that need to be used to convert the EBCDIC character set data to normal characters (readable format) using sql load option.</P><P></P><P>I tried using mapping function to convert EBCDIC data with qlik load file option but not able to use the same mapping function for sql load.</P><P></P><P>Thanks,</P><P>Narasimha</P></BODY></HTML> Sun, 26 Aug 2018 06:34:19 GMT https://community.qlik.com/t5/App-Development/How-to-convert-EBCDIC-character-set-data-using-qlik-view-sql/m-p/122327#M8510 Anonymous 2018-08-26T06:34:19Z Re: How to convert EBCDIC character set data using qlik view sql load https://community.qlik.com/t5/App-Development/How-to-convert-EBCDIC-character-set-data-using-qlik-view-sql/m-p/122328#M8511 <HTML><HEAD></HEAD><BODY><P>I don't recommend doing your own conversion character by character - even with a map.</P><P></P><P>First of all - all ODBC / OLEDB drivers on Windows that support your SQL database can do the conversion for you. EBCDIC is an extended familiy of character sets - not just one. Just like the ASCII/ANSI is ...</P><P></P><P>So be sure to identify which <STRONG>EBCDIC code page</STRONG> your database is set to. Then go into the ODBC-driver and find the conversion options there to specify the source EBCDIC code page and then you should get a Windows readable character set.</P></BODY></HTML> Sun, 26 Aug 2018 16:26:02 GMT https://community.qlik.com/t5/App-Development/How-to-convert-EBCDIC-character-set-data-using-qlik-view-sql/m-p/122328#M8511 petter 2018-08-26T16:26:02Z