sqlite支持
CAST和:
Casting an INTEGER or REAL value into TEXT renders the value as if via sqlite3_snprintf() except that the resulting TEXT uses the encoding of the database connection.
所以你可以做这样的事情:
@H_403_11@select cast(some_integer_column as text) from some_table;或者,根据您想要做的,您可以将数字视为字符串,并让sqlite强制其认为合适的类型:
@H_403_11@select some_int || ' pancakes' from some_table; select some_int || '' from some_table;