I am on MSSQL 2K. The field i am using to store chinese character is defiles as
chinesename nvarchar(50)
Using jsp file (meta tag set to UTF-8) to display form. User fill up the form and submit it. At backend i run servlet and insert into table. When i insert the value i use statements like
insert....value (N'..').
When i view it using Enterprise Manager, i see some weird characters. But still when i use jsp file to retrive all data back, it shows on screen all correct.
But the problem comes when i use these database values and create XML file. In XML file created i see the same as what i see in Enterprise Manager. So PDF rendered also is showing same weird chars.
I know MSSQL uses UCS2 but i am specifying UTF-8 for my jsp ? Any clues on this pls ? How i can have my XML file properly created ?
regards
Manisha
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
