Greetings everyone,
Our database does not currently support unicode. We have been testing it out and keep finding issues with it, so until the issues can be resolved, we have opted out of enabling this function.
In the mean time, we are using the following character " ^ " before the letters "o" and "u" to indicate there should be a line above the letter (unicode equivalent of ō and ū). The problem is then in our reporting functions. I am having issues with the correct formula to use to convert ^o to ō and ^u to ū in the final report.
For the fields where the letter with the symbol appear, I am already using a formula to select the data, so I have to figure out where I can add a new formula to convert the symbol into the unicode character. I have tried to add a formula on the font field under the format field section, but the different formulas I have tried do not work. I keep getting prompts that the rest of the formula is missing or that the formula must be a string. I have also selected an Arial Unicode MS font with the hopes that once I can figure out how to convert the characters to unicode that the font will not cause any issues.
Does anyone else use unicode characters in reports and in their data? Any suggestions on where to try to add formulas to replace text with unicode characters?
Any help is much appreciated. Thanks.