On 04-Apr-2008, at 12:54 PM, Nicolas Williams wrote:
> On Fri, Apr 04, 2008 at 12:48:05PM -0700, Steven Fisher wrote:
>> On 03-Apr-2008, at 11:22 PM, Matthew L. Creech wrote:
>>> We need to either rename it so
>>> that it's part of the library's exported API, or do something
>>> different in tclsqlite.c.
>>
>> I would really like to have a few of sqlite3's internal functions
>> available to client applications in a straightforward manner.
>> sqlite3StrICmp is the top one on my list, though I could see
>> sqlite3StrNICmp and sqlite3IsNumber being useful as well.
>>
>> When comparing column names in my code, for instance, it makes a lot
>> of sense to be able to use the same code for comparison that sqlite3
>> uses. Sure, it's probably the same as stricmp/strcasecmp, but will it
>> always be so? Probably, but it'd be more future-proof just to use the
>> same code.
>
> It's not necessarily the same as strcasecmp().  You can have per- 
> column
> collations.

Column names, not column contents. :) I don't like to have my C code  
rely on the order of columns from a query. You can avoid depending on  
parameter ordering with sqlite3_bind_parameter_index, but there  
doesn't seem to be an equivalent for result columns.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to