Unanswered: Displaying proper character encoding of data from SQL Server
I have my data stored in SQL Server in Unicode. I need to put them in an e-mail (I use JMail component). E-mail's character set is set to iso-8859-2 to have all the static text displayed properly in most of mail agents used in Poland. However, the data that come from the database have all Polish characters replaced with non-Polish substitutes.
The code is written in VBScript.
I'll be grateful for any hints on what I should to to have data displayed properly.