Release Support > Release Discussion

Version 0.70 MSSQL Update Failure

(1/1)

sm69th:
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?

alec:
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.

Navigation

[0] Message Index