Hi, I would like to know if there is some workaround to use group_concat on binary columns.
For performance consideration, I need to query two tables and accomplish data retrieval in a single SELECT. There is this BLOB column, originally designed as BLOB rather than text so that the storage is efficient. So can I use group_concat to join binary columns? I don't know if the implementation actually treats the output column as a string, or it will determine the actual length, in which case, it might be possible. What choices do I have? Is it a good idea to add another column that contains the encoded text representation of the BLOB? Thanks in advance, He Shiming _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users