?
Solved

translate japanese character with ''

Posted on 2011-03-23
3
Medium Priority
?
457 Views
Last Modified: 2012-05-11
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)
0
Comment
Question by:sam2929
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 4

Expert Comment

by:vinaypatki
ID: 35197704
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
 
LVL 37

Expert Comment

by:momi_sabag
ID: 35197871
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
 
LVL 37

Accepted Solution

by:
momi_sabag earned 2000 total points
ID: 35197889
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Suggested Courses

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question