Data Assist Pipe symbol (bug or design)
We use Web Assist products because of their ease. Our company standard is to use the ||| for explode and implode of arrays to strings and vice-versa.
The issue is that Data Assist only inputs the first "array key" of the string to a database field and strips off the rest on an insert or update.
After lots of troubleshooting, we realized that this is from Data Assist and not PHP or MySQL as raw PHP "echo" statements and SQL inserts work perfectly. Since the particular data I'm working with involves 0% chance of a SQL injection, I've chose to skip using Data Assist for these types of issues. However, we would really like to stick to DA for consistency. Is this a bug or a deliberate design and, if so, is there a work-around? I've included a simple example to illustrate what I'm talking about. Try with raw SQL INSERT and then with a Data Assist insert.
$a = '1st line of text';
$b = '2nd line of text';
$c = '3rd line of text';
$wtf_Array = array($a,$b,$c);
$wtf_Implode_String = implode('|||',$wtf_Array);