On 15 May 2012, at 11:25pm, Jeremy Stephens <jeremy.f.steph...@vanderbilt.edu> wrote:
> Is it possible to find the collation setting of a column via SQL? I've > noticed there is a way to do this using the C API (by using > sqlite3_table_column_metadata), but short of parsing the CREATE TABLE command > found in sqlite_master (which does show the COLLATE info), I can't figure out > a way to find this information via SQL. If it's anywhere I'd expect to see it in "PRAGMA table_info(table-name)": <https://www.sqlite.org/pragma.html#pragma_table_info> In the version I'm using … no, it doesn't seem to do it. Sorry: SQLite version 3.7.12 2012-03-31 02:46:20 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> CREATE TABLE twoCols (firstCol TEXT, secondCol TEXT COLLATE NOCASE); sqlite> PRAGMA table_info(twoCols); 0|firstCol|TEXT|0||0 1|secondCol|TEXT|0||0 It doesn't seem to be shown in "PRAGMA index_info(index-name)" either. Sorry. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
