Encoding types and email

Classic Servoy
1

I’m working with the Alphaworks SMTP bean and I’m hitting a problem with the Firebird database I’m using.

I can send a single line email fine. But as soon as I try to send a multi-line email I get a response from the server (in my case qmail) about LF’s not being CR/LF.

http://cr.yp.to/docs/smtplf.html

My database connection string in Servoy is lc_ctype=WIN1252, and the Firebird encoding on the field is WIN1252. The field is a VARCHAR.

Do I need to convert my LF’s to CR/LF’s in a function?
Would a BLOB type field work?
Why won’t EMS Firebird Manager let me change a VARCHAR field to a BLOB without throwing out an error like this…

fmCompile.quCompile:
Undefined name.
Dynamic SQL Error.
SQL error code = -204.
Data type unknown.
Invalid use of CHARACTER SET or COLLATE.

Any of the Servoy devs know anything about MTA’s, MIME and SMTP with regards to SQL fields and CR/LF’s?

Sincerely,

Currently mystified (and tired, 2:06 AM my time)

2

you can use

var mailText = utils.stringReplace(mailText,'\n','\r\n')
```before emailing
most email servers do not have a problem with only '\n' (appently qmail is very strict)