Converting double byte characters to single byte characters in a single string

25 pts.
Tags:
Double-byte
Oracle SQL
Single Byte
converting double byte characters to single byte characters in a single string

Software/Hardware used:
oracle/sql

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    Double-byte characters can't fit in single bytes. Tom
    125,585 pointsBadges:
    report
  • Subhendu Sen
    Hope, this Link will help U !
    29,710 pointsBadges:
    report
  • taskman
    Thanks Guys I know that the double byte want fit in single byte, however the problem that I'm trying to resolve...is to remove the BOM / extra byte...from é and keep it as an é ...however as a single byte instead of double.
    25 pointsBadges:
    report
  • TomLiotta
    Okay, then we can use some details. What DBCS is used for the data? What SBCS should the data convert to? What OS release do you have available? Is this a database field coming in? Can you supply the field definition? A copy/paste from DSPFFD will probably be sufficient. As long as the CCSIDs are compatible, it can be coded. Tom
    125,585 pointsBadges:
    report
  • taskman
    What DBCS is used for the data? UTF8? What SBCS should the data convert to? WE8ISO8859P1 ? What OS release do you have available? Solaris 10 Is this a database field coming in? Database field but coming out of an Oracle table Can you supply the field definition? VARCHAR2 A copy/paste from DSPFFD will probably be sufficient. (text being written to unix) however A45 and B45 have an À TITLEA45 60 TITLEB45 60 TITLEC45 60 So in this example my parser would will start in position 121 but the data in C45 in this case has shifted by two bytes. I hope that I understood your question. Thanks
    25 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following