November 4, 2010 at 7:14 am
Good day, I have a problem in time to shoot an e-mail via sp_send_dbmail procedure, when I put some special character in the subject field, we have some people who receive the e-mail like this (=? Utf-8? B? QWxlcnRhIGRlIERvY ...), was searching the net and found that the problem is Unicode, does anyone know how to force the SQL server Unicode utf-8?
March 28, 2012 at 1:48 am
did you ever find a solution to this problem? We're experiencing the same issue. Everything goes well until the length of the subject passes 179 characters AND it includes the character § (haven't tried with any other character because I need to use this as separator for a 3rd party application). Below that length no problem, larger than 179 without § no problem.
Both SQL Server 2008 SP1 and SQL Server 2008 R2 SP1 seem to have this issue.
It looks like it's related to the combination Outlook-SQL Server-Exchange because I can send a mail from SQL Server to my Gmail account with the "bad" subject line and receive it correctly. Sending a mail from Outlook 2010 with the "bad" subject line to myself works fine again.
September 19, 2012 at 2:58 am
Ok, we have this "sp_send_dbmail" problem, too. Anybody there who has an answer now? I was searching for a solution but still didn't find one.
Thanks in advance.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply