The script to update MS SQL to version 0.70 (I know, I am behind) does not work:
-- Updates from version 0.7
ALTER TABLE [dbo].[contacts] ALTER COLUMN [email] [text] COLLATE Latin1_General_CI_AI NOT NULL
GO
If I manually change the email column to a type of text, my error logs get filled up with these messages:
Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]The data types text and varchar are incompatible in the equal to operator.
I am a bit confused why anyone would want the field "email" to be of the type text anyway?? isn't the varchar(128) that it was sufficient before?
When I change it back to varchar(128) the error messages stop...
Any suggestions?
We're storing many email addresses in this column. The column type has been changed to varchar(8000) in git version and the fix will be available with 0.8-stable release.