I am using sqlite3_column_text16 to retrieve data. The problem is that sqlite3_column_text16 takes the column number as argument. This breaks my existing code if I insert new columns in the beginning of the column list that was specified in the SELECT statement.
I was not able to figure out the right API to get this done. Thanks in advance.