On Thu, Oct 16, 2014 at 9:09 AM, Richard Hipp <d...@sqlite.org> wrote: > On Thu, Oct 16, 2014 at 9:53 AM, John McKown <john.archie.mck...@gmail.com> > wrote: > >> On Wed, Sep 24, 2014 at 9:46 PM, Richard Hipp <d...@sqlite.org> wrote: >> > Please try the latest version of SQLite on trunk to see if that works >> > better. Specifically, apply the patch at >> > >> > http://www.sqlite.org/src/vpatch?from=b2c89ef49cd1&to=ef30e0352b3d >> > >> > -- >> > D. Richard Hipp >> > d...@sqlite.org >> >> Unfortunately, the ASCII vs. EBCDIC issued _does_ make it >> impossible to share a single SQLite data base file between z/OS and >> other ASCII-based SQLite systems. > > > If you store content in EBCDIC, it is retrieved in EBCDIC and if you store > content in ASCII it is retrieved in ASCII, regardless of which platform you > do the storing and retrieving on. I wonder if this is the right approach. > Perhaps the zOS patch should be amended to simply transform EBCDIC->ASCII > on input and ASCII->EBCDIC on output. >
Hum, I'll need to look more closely at the code to see where this would need to be implemented. As I indicated previously, making it work on z/OS was so easy that I didn't need to really look closely at the code itself. I basically compiled and it worked. And this was my first attempt to port something to the z/OS environment, so I was not very knowledgeable about it. I am somewhat more knowledgeable today due to some other porting work that was somewhat more involved. I guess that instead of saying ASCII<->EBCDIC, I need to say more exactly ISO8859-1<->IBM-1047 since there are many "ASCII' and "EBCDIC" code pages. Or does SQLite use UTF-8 internally? Hum, something else to look into. I am not really that familiar with SQLite's internals. Thanks for the thoughts. I appreciate your help. If I have more questions, I guess that I would go over to the sqlite-dev forum. > > >> I haven't looked closely enough at >> the code to see if the big-endian (z/OS) vs. little-endian (Intel) >> storage of integers would also be a problem. >> >> > We do cross-platform database portability tests between x86, sparc, and > PPC, to verify that big-endian vs little-endian is not a factor. Thanks for telling me that. I won't worry about it again. > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- The temperature of the aqueous content of an unremittingly ogled culinary vessel will not achieve 100 degrees on the Celsius scale. Maranatha! <>< John McKown _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
