Trying to insert multiple values of a SET type column using (MariaDB) prepared
statements, but keep running into "Data truncated for column <columnN>" no
matter how the multi-value string is formatted. Processing is done using PHP-8.2.
...
INSERT INTO <table> SET ....<columnN=?> ....;
$BindValuesArray[<columnN>]="'value1,value2,value3'";
$BindVarsArray[]=&${$<columnN>};
$BindParamTypes.="s";
...
extract($BindValuesArray);
So, trying to insert a (multi-valued) "list string" into a SET type column.
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]
