Have a Chinese encoding issue on my DD4T site:

Encoding error

My MVC application already supports the Chinese language for another site - Hong Kong, so I'm pretty confident its not an ASP.NET-side problem.

For this site though, we used new AWS China based kit - so a new Deployer server, new server with SQL Server installed and new server to host the site. We then created a new publication target to this Deployer, linked it to this site's publication and published away!

Its then that we saw the encoding issue.

As we have new kit, I'm suspicious that a setting isn't right. I've double checked everything in Tridion. I checked the package being sent to the Deployer - everything looks OK:

Deployer package

But when I retreive the DCP through the Tridion API, the encoding issue is there:

enter image description here

Does this mean its being stored in the SQL Server with the incorrect encoding?

Are there any JVM settings I can use in case its the JVM - either on the Deployer side or the API side?


Also tried with LINQPad against the new Broker db of the affected application - encoding issue was visible:


For my money its got to be either the Deployer's JVM - which is putting stuff in to the Broker db, the SQL Server database itself - which could be storing it wrong, or the API's JVM which is pulling it out wrong?

After running the same LINQ query against my other Chinese language site's Broker (a different one), I can see everything is as expected:

Other broker

This has got to be JVM or SQL Server right? How can I narrow down my search for the problem?

3 Answers 3


Ok - so I've come across this setting before but for some reason I assumed it didn't apply. I stuck it in and low and behold, encoding back to normal!

I simply added a new System Variable JAVA_TOOL_OPTIONS under Environmental Variables on the Deployer server and gave it the value:


Restarted IIS, republished and BOOM!

  • Aha. I was looking for something along those lines to help you via my answer. Can't say it's anything I've needed to do before myself. I think there's a way to do this in the deployer's config files rather than setting it system-wide Oct 28, 2015 at 13:17

Is this a new Publication Target as well as Deployer, Broker DB etc?

If so, have you checked the Default Code Page setting for the new Target matches the working one?

Publication Target Default Code Page setting

That's the first step in Elena's (in)famous "7 Clues to Solve Character Encoding Issues" blog post. I don't want to re-write her article here, but I'd have a read through that for other possibilities.

  • Thanks Dave - yes, Elena's article is normally my starting point with this sort of thing. I've triple checked the publication target and it is set to UTF-8. As far as I can tell its getting to the Deployer OK but when I pull it out by the API the encoding is wrong - so for my money its got to be either the Deployers JVM - which is putting stuff in, the SQL Database itself - which could be storing it wrong, or the API's JVM which is pulling it out wrong.
    – Neil
    Oct 27, 2015 at 7:51

Looking at the additional information in your question update I see that you can see differences in the stored content against your existing broker DB. In this case if it's not the Publication Target's settings I'd definitely look at the Deployer's JVM configuration.

  • Any tips on how to do that - its just a vanilla HTTP Upload install?
    – Neil
    Oct 27, 2015 at 9:28
  • Running on IIS as a .Net web application or something else? Oct 27, 2015 at 9:28
  • IIS & ASP.NET MVC application.
    – Neil
    Oct 27, 2015 at 10:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.