sam2929
asked on
translate japanese character with ''
Hi ,
i have japanese chracter which looks like below i want to remove them i am on 9.1 aix. how can i do it.
Thanks
aa ¿¿¿¿¿¿¿¿¿¿ Notes¿¿¿¿¿¿¿¿¿¿¿¿
want it to look like aaNotes
(Sorry looks like expert exchange converted them to question mark but this is japnese chracter in real)
i have japanese chracter which looks like below i want to remove them i am on 9.1 aix. how can i do it.
Thanks
aa ¿¿¿¿¿¿¿¿¿¿ Notes¿¿¿¿¿¿¿¿¿¿¿¿
want it to look like aaNotes
(Sorry looks like expert exchange converted them to question mark but this is japnese chracter in real)
depending on the encoding you use, those japanese characters are using a specific range of values (each value represents a character)
you could write a user function which remove the characters with those values, or you could try to use an existing function such as replace and translate
http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/r0000862.htm?resultof=%22%74%72%61%6e%73%6c%61%74%65%22%20%22%74%72%61%6e%73%6c%61%74%22%20
which works on the characters and not their numeric values (might be easier)
you could write a user function which remove the characters with those values, or you could try to use an existing function such as replace and translate
http://publib.boulder.ibm.com/infocenter/db2luw/v9/topic/com.ibm.db2.udb.admin.doc/doc/r0000862.htm?resultof=%22%74%72%61%6e%73%6c%61%74%65%22%20%22%74%72%61%6e%73%6c%61%74%22%20
which works on the characters and not their numeric values (might be easier)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://www.justskins.com/forums/insert-french-character-to-120500.html
Sorry for providing link rather than a solution. Could understand upto a limit...