Hmmm.. I can't believe I missed that.. Thanks for the info. If it's a matter of creating a function in SQL to replicate spaces (or something else) at the end of the string, I can code that easily enoug (called RPAD).
Wouldn't varchar types probably be a better usage in this scenario. I'll play with it more (work on some possible solutions and report back). Coincidentally, if you have the code (mysql or otherwise) for RPAD, I could just look at it and mangle for MS SQL to see if it helps/works. Thanks again. Steven -----Original Message----- From: Michael Parker [mailto:[EMAIL PROTECTED] Sent: Friday, May 13, 2005 12:38 PM To: Steven Manross Cc: users@spamassassin.apache.org Subject: Re: SQL Question > debug: bayes: tok_get_all: Token Count: 302 > debug: bayes: tok_get_all: SQL Error: [Microsoft][ODBC SQL Server Driver][SQL Se > rver]'RPAD' is not a recognized function name. (SQL-42000) > [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepare > d. (SQL-42000)(DBD: st_execute/SQLExecute err=-1) > debug: cannot use bayes on this message; none of the tokens were found in the da > tabase This is the problem, SQL Server doesn't know what the RPAD function is. How does SQL Server handle Char types? does it return spaces at the end of the string? MS SQL Server might need at a custom module to handle things correctly. Michael
