Trying to load a specific Traditional Chinese Character on an HP UX platform for a Taiwan database. Data is converting to ?. Database has existed since 2008 and this is the first issue I've seen where a user is unable to save the multi-byte character in the database. I'm thinking this is may be an issue with Character set file and am wondering if I need a conversion map modified. Database uses Big-5 code page.
User keys in
But the data is converting and storing as ? (second symbol changes to ?)
NOTE: I added spaces above to better visualize the data
---------- Post updated 04-25-14 at 01:55 PM ---------- Previous update was 04-24-14 at 03:57 PM ----------
Received an email today from a Translation specialist of our ERP Vendor who stated
"I searched for the character "" on a BIG-5 character code table (http://ash.jp/code/cn/big5tbl.htm\) and also on a BIG-5 to Unicode table (http://www.unicode.org/Public/MAPPINGS/OBSOLETE/EASTASIA/OTHER/BIG5.TXT\) and was unable to find it in these two tables.
So, the conclusion is that the character "" is not one of BIG-5 characters. The only way to display the character correctly is by using Unicode encoding to import/export.�
In other words the particular character we are trying to enter is not supported for Big-5 code page.
Please consider this issue closed.