If what appears is what was entered, then you need to change the closing ’ to a closing ' (that is, from a funny word-processor symbol that looks like a quote but is really an apostrophe used in typesetting but is not a quote that terminates a string, into a quote to terminate the string) ...
sqlite> select load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib’); sqlite> select load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib'); You have to be careful because most modern e-mail clients, unless specifically configured otherwise, are designed specifically for sending web-pages containing glossy-brochures by SMTP and are not suitable for use in exchanging plain-text that must not be tampered with. In this case the culprit was likely a configuration option that substituted "pretty quotes" and "apostrophes" for functional quotes. You can tell because the pretty-quotes are, well, pretty and curvy, such as are around your original “median”, while actual quotes that-do-something (other than look pretty) do not have curves: "median". The same mis-feature also changes single-quotes ' into apostrophes ’ in the circumstances it thinks such changes are appropriate depending on its substitution rules. > -----Original Message----- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Ronald Gombach > Sent: Wednesday, 23 November, 2016 04:57 > To: SQLite mailing list > Subject: Re: [sqlite] SQLite binary with Math Functions for OS-X? > > David, > > The brew/install worked and created the sqlite app and library in the > locations specified in your instructions. > > I can load the math lib from the .load (dot load) command line, > The median function works as I wanted > > but the ‘load_extension’ select statement did not work; I get a command > entry continuation line as follows > > sqlite> select > load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib’); > …> > > I need to be able to load the extension from within a PHP script > > Thoughts? > > Thanks. > > Ron Gombach > mailto:ron...@gombach.com <mailto:ron...@gombach.com> > > > > On Nov 21, 2016, at 12:15 PM, David Goldwich > <david.goldwich+sql...@gmail.com> wrote: > > > > On Mon, Nov 21, 2016 at 1:12 PM, Ronald Gombach <ron...@gombach.com> > wrote: > >> > >> Is there a pre-c binary of SQLIte available for down load that includes > a math library. I particularly need the “median” function. > >> > >> If not, can someone point me to instructions on compilation command > line to include the math library (OS-X). > > > > Homebrew can do that conveniently: > > > > $ brew update && brew install --with-functions sqlite > > $ /usr/local/opt/sqlite/bin/sqlite3 > > sqlite> select > load_extension('/usr/local/opt/sqlite/lib/libsqlitefunctions.dylib’); > > sqlite> select pi(); > > pi() > > 3.14159265358979 > > > > The “math library” here being extension-functions.c from > > https://www.sqlite.org/contrib/. > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users