Having a little issue with handling Json in datasources

1) it seems to omit collumns that have a '#' in their collumn name

2) while the Json array validates fine on its own , converted to XML it also looks good and infact the xml then displays fine in the Datasources, the same data as Json displays minimum 1 'a:item' as column name and omits the following collumn

The data is pulled from external Mysql tables , and while i noticed omitting the '#' in a collumn name will solve point 1 ( i technically have no control on those collumnames ) point 2 is a bigger concern as i am missing data as a result

any ideas or is it really a bug

EDIT: FOUND IT ....No spaces, - , # etc allowed in the collumn names !!

not really a solution if one can not change the source :-(