Forum Discussion

k3rz0rg's avatar
k3rz0rg
Icon for Advocate III rankAdvocate III
8 years ago

How 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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

k3rz0rg,

I have no issues connecting to Oracle and writing SQL query in Power BI Desktop. Have you tried to execute the SQL query in SQL developer and check if it is successful?

Regards,
Lydia

k3rz0rg's avatar
k3rz0rg
Icon for Advocate III rankAdvocate III
8 years ago

Anonymous

 

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