[sqlite] Function patternCompare() not EBCDIC friendly

2015-12-31 Thread mario bezzi
E_R=1 \ > -DHAVE_DECL_STRERROR_R=1 \ > -DHAVE_STRERROR_R=1 \ > -D_REENTRANT=1 \ > -DSQLITE_THREADSAFE=1 \ > -DSQLITE_ENABLE_FTS3 \ > -DSQLITE_ENABLE_RTREE \ > -O3 \ > -I. -V \ > -DSQLITE_OMIT_MERGE_SORT \ > -DSQLITE_MAX_MMAPSIZE=1048576 \ > -qTARG=zOSV1R11 \ > -q

[sqlite] Function patternCompare() not EBCDIC friendly

2015-12-31 Thread David Clark
Roland, Congrads on getting something to work with sqlite and z/OS. ?How did you resolve the file I/O issues, or did you have any. ?I figured sqlite should be able to run on z/OS a few years back due to the portable nature of the code I saw. ? But the?mainframe guys who supposedly knew, told

[sqlite] Function patternCompare() not EBCDIC friendly

2015-12-30 Thread mbezzi
t; > -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 patternCompar

[sqlite] Function patternCompare() not EBCDIC friendly

2015-12-30 Thread Roland Martin
X_C_SOURCE=200112L \ -D_XOPEN_SOURCE=600 \ -c \ -o shell.o shell.c Linking the two together for a sqlite3 executable: xlc -q64 -o sqlite3 shell.o sqlite3.o Hope this helps - Roland -----Original Message- From: mbezzi [mailto:mbe...@tiscali.it] Sent: Wednesday, December 30, 2015 11:21 AM To: SQLite ma

[sqlite] Function patternCompare() not EBCDIC friendly

2015-12-30 Thread John McKown
On Wed, Dec 30, 2015 at 9:55 AM, Roland Martin wrote: > I have tested the code change on z/OS and it works. > ?Any chance that I could beg the source and executable code from you? > > Thanks for the quick turnaround! > > Roland Martin > > -- Computer Science is the only discipline in which

[sqlite] Function patternCompare() not EBCDIC friendly

2015-12-30 Thread Roland Martin
at gmail.com Subject: Re: [sqlite] Function patternCompare() not EBCDIC friendly On 12/30/15, Roland Martin 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/sr

[sqlite] Function patternCompare() not EBCDIC friendly

2015-12-30 Thread Richard Hipp
On 12/30/15, Roland Martin 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] Function patternCompare() not EBCDIC friendly

2015-12-30 Thread Roland Martin
Working with version 3.9.2 on IBM z/OS case insensitive LIKE queries do not work if case does not match. The following #if defined(SQLITE_EBCDIC) is important: /* ** For LIKE and GLOB matching on EBCDIC machines, assume that every ** character is exactly one byte in size. Also, provde the