What is the equivalent of string_to_array from postgreSQL for SQLite?

Question

PHP

Actually the question is in the title. The bottom line is that the execute method in PDO on a named marker does not accept an array. But I know that postgreSQL has a string_to_array method, but I can’t google the analogue in SQLite. There is not one named marker, there are 2 of them and each has different data. Tell me how to get out.

Answer 1

PDO knows nothing about what postgresql can do with arrays.
If you need to save an array and maintain compatibility with multiple databases - then use serialize / deserialize, or even better json_encode / json_decode. Store the field as text.