Converting from CCSID 65535 to ASCII

IBM / nodejs-idb-connector

A JavaScript (Node.js) library for communicating with Db2 for IBM i, with support for queries, procedures, and much more. Uses traditional callback-style syntax

MIT License

37 stars 23 forks source link

Converting from CCSID 65535 to ASCII #52

Closed abmusse closed 5 years ago

abmusse commented 5 years ago

Original report by Michael Franchino (Bitbucket: michaelfranchino, GitHub: michaelfranchino).

I am very new to this, all the tables are setup as 65535, my profile is setup with CCSID of 37,

I don't know if I missed the documentation or what, but when I do the retrieve, I am getting back an array of EBCDIC values. How do I force it to convert to ASCII?

I read through the issues but didn't see anything that gave this away.

abmusse commented 5 years ago

Original comment by Michael Franchino (Bitbucket: michaelfranchino, GitHub: michaelfranchino).

My issue is that ALL the tables are coded as *HEX, which is CCSID 65535. After I change the file to CCSID, everything is working. Not sure what to do, as I am not sure that changing EVERY table for MAPICS is going to be ok.