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?