Finally got this to work in SQL workbench/J, using the jt400 jdbc property
bidi string type=4
Unfortunately IBM i Access – client services / Run SQL function does not have the ability to configure this driver property, it is set to 5 by default. Have raised an RFE for this.
Many thanks to Mike/IBM for the assistance. I hope someone else finds this useful.