I have a problem.
I created a web interface which is required to allow japanese input and insert the text into SQL server 2000 DB.
The XML, returned by the SP that get data from DB, is able to retrieve the Japanese Text and showing them in my debug page, even without using nVarchar data type at Field.
However, seems my current XSL can not represent what we have got in the XML by display the gibberish like
Now, on the header of my current XSL has this :
<xsl:output method="html" encoding="iso-8859-1" indent="yes" doctype-public="-//W3C//DTD HTML 3.2 Final//EN" />
And in this XSL file there're a lots of logic,switching between multiple Language (including japanese) based on the user profle, to display messages in those languages hard coded there.
Could you guys help me figure out a way to represent the Japanese Text from the Backend which already correctly contained in the XML in the current context.