On 11/21/07 1:08 PM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> > In addition, I've worked with DB2 previously on a z/OS system utilizing the > type driver supplied by IBM. The database was expecting EBCDIC and the data I > was working with in the Java world was ASCII coming in from an XML document > encoded in UTF-8. The JDBC driver did a marvelous job of converting the ASCII > to EBCDIC for me without me even needing to think about it. However, one thing > that you must be aware of is that there are ASCII characters that do not map > to EBCIDIC characters and there are EBCDIC characters that do not map to ASCII > characters. This is something that I spent a great deal of time on, trying to > map some obscure characters to the back-end system because it was required. > The end result was utilizing triggers to get around some of the issues. Out of curiosity, is EBCIDIC's lower range the same as ASCII like Unicode? Cheers, Chris
