Sunday, February 26, 2012

Browser is failing to render Japanese characters in Data Service response


WCF  data services failed to display record for the several languages such as Japanese when used via Devart Data Driver . It renders some junk characters for Japanese values but English is fine, Bellow is the sample
        <d:FullName>¿¿ ¿¿</d:FullName>

Root Cause

By default“Dot Connect for Oracle” data driver uses default setting Unicode=False  .

I am surprise why, even though it is industry standard?

Explicitly Enable Unicode settings in connection string used in webconfig file 

<add name="MyEntities" connectionString="…………provider=Devart.Data.Oracle;provider connection string=&quot;User Id=***;Password=***;Unicode=true;Server=***;Direct=True;Sid=***;Port=***;Persist Security Info=True&quot;" providerName="System.Data.EntityClient" />

No comments:

Post a Comment