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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-05 : 00:37:11
|
Roger writes "I have a problem that I have been completely unable to find any information about. The same problem occurs on my development SQL Server 7.0 and the production SQL Server 7.0 at the company I work for.
The problem is that when using SQLMail to send emails, all non English characters (like the Norwegian æ, ø and å) change to other symbols in the emails. The same thing happens in any attachments that are created.
for instance:
xp.sendmail 'rogerdahl@dahlsys.com', 'æøå'
generates an email with three other symbols in it.
I wrote a small t-sql program that generates an email with all characters from 0 to 255 with the char(n) function, and the correct characters do appear in that email. For instance:
declare @vc varchar(100)
set @vc = char(230)
exec master..xp_sendmail 'rogerdahl@dahlsys.com', @vc
generates an email with the letter 'æ'.
Any help you could give me on this subject would be much appreciated.
Roger Dahl
SQL Server 7.0 latest SP
Windows 2000 SP1" |
|
|
|
|
|
SQLMail and non English character sets