storing and reteriving unicode char in SQL database

[Mann Khine]

I'm trying to show japanese character on the page and to sent mail. To show on the screen, I've to save as the following format in SQL Server. "**

ƒtƒBƒŠƒbƒvØŒ”ƒIƒ“ƒ‰ƒCƒ“ŒûÀ\‚µ

**" and use encoding "shift-jis". It is showing correctly at browser. But if I send mail that message, it can't be shown on some mail. eg. gmail and hotmail can show but yahoo can't show correctly. If I store as the following format in SQL Server, it can show correctly on most of the web mail. " & #12458 ; & #12531 ; & #12521 ; & #12452 ; & # 12531 ; & #21475 ; & #24231 ;" Can anybody explain about these formats? Can anybody advice me for the best practise dealing with unicode character? I would like to use same format to show and to send for unicode character. I'm using classic ASP for server side script. Thanks in advance, Mann Khine

[Ashfield]

Have you tried using nvarchar columns in your database?

Bob Ashfield Consultants Ltd

[Mann Khine]

Yes Bob, I used nvarchar columns.

[Ashfield]

Just a thought, suspected you already had. Could it be the format of the mail message? I know there are problems with extended charater sets when the email client only displays plain text.

Bob Ashfield Consultants Ltd