Toad World® Forums

ORA-29275: partial multibyte character

Hi,

We have recently converted our 11g DB character set to UTF8, since then we are not able to view data in the data grid for some of the columns that has encrypted data.

How can this be resolved? We do not have any issues when we use SQLDeveloper to view data.

Thanks,

Narmada

If it’s Oracle’s Transparent Data Encryption, there shouldn’t be anything that you have to do in Toad to see the data. If it’s some other kind of encryption, I guess I’ll need more information.

We are using DBMS_OBFUSCATION_TOOLKIT.desencrypt to encrypt and store the data into varchar2 column of a table.

OK. Toad doesn’t have any built-in mechanism to automatically decrypt columns that are encrypted that way. You’d have to include the decrypt calls in your SQL statement. I don’t know what SQLDeveloper is doing, but if you feel it’s a bug in Toad, I’ll need some steps to reproduce the problem.

I used that toolkit some time back to create a Web based password vault under 9i. If I remember correctly, I had to use RAW or BLOB data types to hold the encrypted data. Not sure if the toolkit is improved or different/better these days as I haven’t needed to use it lately.

HTH.

Cheers,

Norm [ TeamT ]

On 5 January 2015 22:02:20 GMT+00:00, ndacherla bounce-ndacherla@toadworld.com wrote:

RE: ORA-29275: partial multibyte character

Reply by ndacherla
We are using DBMS_OBFUSCATION_TOOLKIT.desencrypt to encrypt and store the data into varchar2 column of a table.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

Sent from my Android device with K-9 Mail. Please excuse my brevity.

John,

I am trying to display encrypted data… it works fine for non utf8 DB.

Does the encryption result in null (0) character as part of it? Select from that column so that you see the data in hex (the Oracle function to do so slips my
mind) and look for null character. If you see this then Toad will only display the data up to the null as null character terminates strings in the language Toad is written in, Delphi. Do not select from the column and then use Toad’s built-in hex viewer as
this will not work.

From: ndacherla [mailto:bounce-ndacherla@toadworld.com]

Sent: Tuesday, January 06, 2015 10:13 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] ORA-29275: partial multibyte character

RE: ORA-29275: partial multibyte character

Reply by ndacherla

John,

I am trying to display encrypted data… it works fine for non utf8 DB.

To reply, please reply-all to this email.

Stop receiving emails
on this subject.

Or Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

http://04j0.mjt.lu/o/04j0/721d1703/g0zu2hxe.gif

Hi Narmada,

The best way we can help you is if you can provide us specific information on what you’re doing, what you’re attempting to do, what your operating environment is like, and what is being output.

So far, all we know is:

  1. You’re presumably using Toad

  2. You have Oracle 11g

  3. You’re using DBMS_OBFUSCATION_TOOLKIT

  4. Something works in SQL*Dev and not in Toad.
    I hope you can see that from our point of view, there’s not really a lot to go on here. The details are important, so some information that would be a good start for troubleshooting might be:

  5. Version of Toad, including 32/64-bit

  6. Version of Windows

  7. Specific Oracle server version/platform

  8. Specific Oracle client installation and version

  9. Example SQL statement and the means to recreate it (e.g. table layout).
    It might also help knowing if your SQL*Dev and Toad are both using the same Oracle Client.

You’re getting into the fun world of encryption and (potentially) character set translations in Oracle, and it can be a bit of a challenge. Let us know more details about your setup and hopefully we can help you troubleshoot!

Rich

Select dump (column, 16) from … where …;

Cheers,

Norm [ TeamT ]

On 6 January 2015 15:18:51 GMT+00:00, Michael Staszewski bounce-mstaszew@toadworld.com wrote:

RE: ORA-29275: partial multibyte character

Reply by Michael Staszewski
Does the encryption result in null (0) character as part of it? Select from that column so that you see the data in hex (the Oracle function to do so slips my mind) and look for null character. If you see this then Toad will only display the data up to the null as null character terminates strings in the language Toad is written in, Delphi. Do not select from the column and then use Toad’s built-in hex viewer as this will not work.

From: ndacherla [mailto:bounce-ndacherla@toadworld.com]
Sent: Tuesday, January 06, 2015 10:13 AM
To: toadoracle@toadworld.com
Subject: RE: [Toad for Oracle - Discussion Forum] ORA-29275: partial multibyte character

RE: ORA-29275: partial multibyte character

Reply by ndacherla

John,

I am trying to display encrypted data… it works fine for non utf8 DB.

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

http://04j0.mjt.lu/o/04j0/721d1703/g0zu2hxe.gif

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag this post as spam/abuse.

Sent from my Android device with K-9 Mail. Please excuse my brevity.