Hi all,
I'm building a site that pulls its content from an SQL Server database, which stores both English and Japanese versions of the content.
I've got it working so that I can store and retrieve japanese text using ASP, and the stored text displays correctly on the web.
However, when I look at the stored data in SQL Server Enterprise manager/SQL Query Analyser, the text is displayed in what looks like ascii characters:
私は日本翻訳を愛する
I think you may need to view source on this page to see - as the html page in this forum is processing the ascii code and displaying the japanese text you probably see above...
The ampersands and hash keys etc make me think that it's storing the text in some kind of web-mode, in the same way that we use ">" for a > or £ for a £
If this is the case, I think I must be doing something wrong - I ideally would like to see the actual Japanese characters in my Enterprise manager - I'm pretty sure I've got the correct fonts installed, as otherwise I wouldn't be able to view it on the web!
I've tried using the unicode prefix N on insert/update, but this doesn't seem to make any difference. The column collation is set to Japanese as well.
Can anyone tell me what I'm doing wrong?
Many thanks,
Bluze
I'm building a site that pulls its content from an SQL Server database, which stores both English and Japanese versions of the content.
I've got it working so that I can store and retrieve japanese text using ASP, and the stored text displays correctly on the web.
However, when I look at the stored data in SQL Server Enterprise manager/SQL Query Analyser, the text is displayed in what looks like ascii characters:
私は日本翻訳を愛する
I think you may need to view source on this page to see - as the html page in this forum is processing the ascii code and displaying the japanese text you probably see above...
The ampersands and hash keys etc make me think that it's storing the text in some kind of web-mode, in the same way that we use ">" for a > or £ for a £
If this is the case, I think I must be doing something wrong - I ideally would like to see the actual Japanese characters in my Enterprise manager - I'm pretty sure I've got the correct fonts installed, as otherwise I wouldn't be able to view it on the web!
I've tried using the unicode prefix N on insert/update, but this doesn't seem to make any difference. The column collation is set to Japanese as well.
Can anyone tell me what I'm doing wrong?
Many thanks,
Bluze