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)
sam2929Asked:
Who is Participating?
 
momi_sabagCommented:
using translate will be the simplest solution,
something like


select translate(column_to_be_translated, '', 'all your japanese characters come here')

this will translate all the japanese characters to spaces,
then

select replace(translate(column_to_be_translated, '', 'all your japanese characters come here'), ' ', '')
 

will remove those spaces
0
 
vinaypatkiCommented:
See if this can help.
http://www.justskins.com/forums/insert-french-character-to-120500.html

Sorry for providing link rather than a solution. Could understand upto a limit...
0
 
momi_sabagCommented:
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)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.