Re: [GENERAL] EBCDIC conversion

2014-03-28 Thread David W Noon
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 28/03/14 00:31, David W Noon wrote: I think the real issue is that you need icu or libiconv installed. You will also need to know which EBCDIC code page you want: U.S. EBCDIC is cp37, IIRC. I suspect you will need to write a C or Python

[GENERAL] EBCDIC conversion

2014-03-27 Thread Mike Blackwell
We have a need to check certain text fields to be sure they'll convert properly to EBCDIC. A check constraint with a convert() was the initial thought, but there doesn't seem to be a default conversion from UTF8 to EBCDIC. Does anyone have an implementation they'd care to share, or suggestions

Re: [GENERAL] EBCDIC conversion

2014-03-27 Thread David W Noon
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 27/03/14 19:08, Mike Blackwell wrote: We have a need to check certain text fields to be sure they'll convert properly to EBCDIC. A check constraint with a convert() was the initial thought, but there doesn't seem to be a default conversion