Search code examples
phpmysqldelimiterexplode

The best delimiter to explode/implode a text string - @, !, <>, # or |

Suppose the text doesn't contain special symbols (doesn't contain @,!, <>, #, | etc).

I've read PHP Delimiters manual and the answer from there 

Anonymous
other possible delimiters include @,!, <>
using symbols (such as | ) that have meaning inside a regex as delimiters is probably going to be counterproductive.

So, what symbol(s) would you use as a delimiter for the text to store the text in one cell of mysql table? The explanation with pros and cons is much appreciated.

Solution

  • When it comes to saving a list to a database in a single text cell, I go for either serialization or use JSON.