Posted by David Haynes on 04/17/06 18:36

news@celticbear.com wrote:
> I'm making a recipe database, and need to have DB fields in mySQL that
> will have lists of values that would get sent to an array to be worked
> on.
>
> I anticipate that at times a comma will need to be used in the value
> itself. So, what's a commonly used symbol or something that people tend
> to use as a separator of a list that would then be used in the split()
> function to send the elements into an array?
>
> Nearly every punctuation has a chance of being in the actual data. Any
> suggestions?
>
> Thanks!
> Liam
>
Usually the vertical bar '|' is a good choice.

-david-

• Next in forum: Re: seperator instead of a comma for listed items in DB?
• Prev in forum: seperator instead of a comma for listed items in DB?
• Thread view: Re: seperator instead of a comma for listed items in DB?

[Reply to this message]