Re: [sqlite] sqlite3_create_function in delphi

[juan perez]

They said it works only with plain (7-bit) ascii, no UTF.

Dennis Cote wrote:

Miha Vrhovnik wrote:

Does anybody know how to add custom function to sqlite3 in Delphi? Cariotoglou Mike?

I'd like to add function 'Lower' so I can match case insenisitive text columns in table.

Regards,
Miha

There is a already a function lower() built in to SQLite. It returns a lowercase copy of a string.

Dennis Cote