On August 13, 2019 5:58:54 p.m. EDT, Manuel Rigger <rigger.man...@gmail.com> wrote: >Hi everyone, > >Is there a simple way to determine the collating function of a column? >PRAGMA table_info does not seem to provide this information. The >information could be extracted from sqlite_master, which contains the >SQL statements used to create the table or view. While parsing the SQL >string is rather straightforward for tables, it would involve more >effort to determine the collating functions for views, which can again >reference other views or tables. > >Best, >Manuel >_______________________________________________ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
I'm not aware of any means beyong parsing the statement. This is doubly annoying because the index_xinfo pragma does list the collation sequence of index columns. -- J. King _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
