Roland, I am pleased to see that you are successfully using SQLite on z/OS. Are you using the standard amalgamation? Did you need to apply special mods to SQLite to work on z/OS? Would you mind sharing your build procedure?
Few months ago I tried compiling SQLite on z/OS: It worked but the data-bases generated on z/OS contains text data in EBCDIC format, including metadata, which makes those data-bases unusable on other platforms. The opposite was also true in my experience: Data-bases created on other platforms (I tried Linux) are not usable on z/OS for the very same reason. At that time I've spent some time trying to find where SQLite required to be modified to change this behavior, but this resulted a too hard assignment given my limited understanding of SQLite internals. Did you face the same issue? Did you find a solution? Anybody willing to help here giving guidance on what should be changed in SQLite to have text data and meta-data stored in UTF-8 format under z/OS? Thank you, mario On 12/30/2015 04:55 PM, Roland Martin wrote: > I have tested the code change on z/OS and it works. > > Thanks for the quick turnaround! > > Roland Martin > > -----Original Message----- > From: drhsqlite at gmail.com [mailto:drhsqlite at gmail.com] On Behalf Of > Richard Hipp > Sent: Wednesday, December 30, 2015 9:08 AM > To: SQLite mailing list > Cc: rolandsmartin at gmail.com > Subject: Re: [sqlite] Function patternCompare() not EBCDIC friendly > > On 12/30/15, Roland Martin <rolandsmartin at gmail.com> wrote: >> Working with version 3.9.2 on IBM z/OS case insensitive LIKE queries >> do not work if case does not match. > > Please test and let us know if the > https://www.sqlite.org/src/info/0a99a8c4facf65ec check-in fixes your problem. > > -- > D. Richard Hipp > drh at sqlite.org > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
