Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 sp_OAMethod Send Chinese Character Problem

Author  Topic 

sinva
Starting Member

23 Posts

Posted - 2010-05-19 : 18:51:59
Dear All,

I am having a problem when I want to use the system stored procedure sp_OAMethod to send an email containing Chinese Character I have "?" instead of the correct character, is there any property I should set before? The content is already declared as datatype NTEXT.

Thanks in advance

sinva
Starting Member

23 Posts

Posted - 2010-05-23 : 22:22:14
Solved. I have added the property "@hr = sp_OASetProperty @email, 'BodyPart.CharSet', 'big5'"
Go to Top of Page
   

- Advertisement -