I respectfully disagree, Roger, about the simplicity. Creating an external DLL would complicate my distribution scenario significantly because I'll have just as many users of my little database application working with Apple OSX as with Windows. I guarantee you, it would be easier for the very skilled programmers at SQLite to set these functions up to be included|excluded by throwing a few compiler switches (as they do for soundex() ) than for me to make my own external library for both OSX and Windows platforms. Basing that strictly on my own set of limited competencies.
BTW, the Microsoft SQL Server 2000 reverse() function does it codepoint by codepoint, and their substring() function also splits combining characters from base characters; the len() function counts codepoints too, and does not merge combining forms and base forms into one unit. Regards Tim Romano Roger Binns wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Tim Romano wrote: > >> This would be a convenient function to have. Are there technical >> issues/obstacles? >> > > In general for all these feature requests for more functions there is no > need for them to be added to the SQLite core. There is a very simple API > and extension mechanism whereby you can add your own functions that do > exactly what you want. > > Roger > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.9 (GNU/Linux) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iEYEARECAAYFAksEN2kACgkQmOOfHg372QTmXgCglwgqyLB6ouPgOmj0M8s3wD3M > cEYAoKD2bWVUnvR4e7DnaBFC6kVbOM+c > =t3xA > -----END PGP SIGNATURE----- > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > ------------------------------------------------------------------------ > > > No virus found in this incoming message. > Checked by AVG - www.avg.com > Version: 8.5.425 / Virus Database: 270.14.72/2511 - Release Date: 11/18/09 > 07:50:00 > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users