Forum Discussion
k3rz0rg
Advocate III
Advocate IIIHow to get around with partial multibyte character issue?
Hi all, I've been working with oracle db and lately facing an issue regarding partial multibyte character. it says DataSource.Error: ORA-29275: partial multibyte character Details: DataSo...
k3rz0rgAdvocate III
Advocate IIIAnonymous
Well, connecting to oracle is good; it's the point of entry where the user inserted the data in different characterset. We have users all around the world and problem occurs mostly from the euro side when they use special characters for names or addresses in their own utf or ascii sets.
I've been looking for a way to convert that while fetching the data with query.
-K3
k3rz0rg,
How about you use the function described in the following blog to convert the row?
http://www.dba-oracle.com/t_ora_29275_partial_multibyte_character.htm
Regards,
Lydia
This link is not working