CiviCRM Community Forums (archive)

I am getting some really weird characters around some of my content.  The content is from some custom fields.  The custom fields are check boxes, and the check box data is the only one with the strange characters.

The character is like a small white box with binary in it 0001.  CiviCRM is outputting these characters, they are not contained in the fields values.

Anyone see this before?  What's the fix?

Hi,

Well spotted.

The fix would be to split these custom fields with multiple value on 0001 and return it as array. Want to give it a go ?

Is there a way to trim out that character?  Or do I need to treat these as an array, and split them?

Yes, that's the way of storing a multivalue field into a single column. You'd need to split on that char. It would be awesome if you find a way of doing it in the API so we get it working out of the box directly.

X+

"word separator"?  Hmm, that sounds interesting.  I will try treating it as an array and split using php, and see if that works for now.  I can then research the multivalue character using the API.  I am sure there is a way to make it work.  I am also sure that I am not the first person to have this issue.

How would I actually split according the that character?  What is that character?

@lobo - I can't seem to find CustomOption, is that v3?  Could you get me started with a simple snippet?

the functions in http://forum.civicrm.org/index.php/topic,18567.0.html are my GET functions for the option groups & option values tables. I haven't created them as an API because we'd need a test for them