There may be a way with the join node but to get you Moving...
If you set the join node to return an array you can use a function node and the array join function...
msg.payload = msg.payload.join("");
return msg;
[{"id":"e4c8f37e.e68bf","type":"mqtt in","z":"83586cc2.a740b","name":"","topic":"PICTURE","qos":"2","datatype":"auto","broker":"d8f5182d.3296f8","x":680,"y":260,"wires":[["8f9355f.de3b6a8","ab2fae17.d62bc"]]},{"id":"8f9355f.de3b6a8","type":"debug","z":"83586cc2.a740b","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":690,"y":320,"wires":[]},{"id":"ab2fae17.d62bc","type":"join","z":"83586cc2.a740b","name":"","mode":"custom","build":"array","property":"payload","propertyType":"msg","key":"topic","joiner":"","joinerType":"str","accumulate":false,"timeout":"5","count":"","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"num","reduceFixup":"","x":910,"y":260,"wires":[["eac5aa92.3bfa88","1a8e17de.257778","34cfbe74.8a22a2"]]},{"id":"eac5aa92.3bfa88","type":"mqtt out","z":"83586cc2.a740b","name":"","topic":"RETURN","qos":"","retain":"","broker":"d8f5182d.3296f8","x":1080,"y":200,"wires":[]},{"id":"1a8e17de.257778","type":"function","z":"83586cc2.a740b","name":"","func":"msg.payload = msg.payload.join(\"\");\nreturn msg;","outputs":1,"noerr":0,"x":1090,"y":260,"wires":[["bb42a927.ae2ee8"]]},{"id":"f9235532.ebf288","type":"inject","z":"83586cc2.a740b","name":"","topic":"","payload":"abc","payloadType":"str","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":690,"y":100,"wires":[["9f60da6a.6aad28"]]},{"id":"ccc06cfb.87e3a","type":"inject","z":"83586cc2.a740b","name":"","topic":"","payload":"123","payloadType":"str","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":690,"y":140,"wires":[["9f60da6a.6aad28"]]},{"id":"bcfa9365.1497","type":"inject","z":"83586cc2.a740b","name":"","topic":"","payload":"xyz","payloadType":"str","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":690,"y":180,"wires":[["9f60da6a.6aad28"]]},{"id":"9f60da6a.6aad28","type":"mqtt out","z":"83586cc2.a740b","name":"","topic":"PICTURE","qos":"","retain":"","broker":"d8f5182d.3296f8","x":920,"y":100,"wires":[]},{"id":"bb42a927.ae2ee8","type":"debug","z":"83586cc2.a740b","name":"","active":true,"tosidebar":true,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","x":1250,"y":260,"wires":[]},{"id":"34cfbe74.8a22a2","type":"debug","z":"83586cc2.a740b","name":"","active":true,"tosidebar":true,"console":false,"tostatus":true,"complete":"payload","targetType":"msg","x":930,"y":320,"wires":[]},{"id":"d8f5182d.3296f8","type":"mqtt-broker","z":"","name":"ESP32CAM_MQTT_01","broker":"192.168.0.102","port":"1883","clientid":"","usetls":false,"compatmode":true,"keepalive":"5","cleansession":true,"birthTopic":"","birthQos":"0","birthPayload":"","closeTopic":"","closeQos":"0","closePayload":"","willTopic":"","willQos":"0","willPayload":""}]
