make it clear that Text() is generally an "unlengthed" type

[Former user]

On SQLServer, creating a table with a column of type sqlalchemy.Text(50) gives the error Cannot specify a column width on data type text.

General advice is to use the VARCHAR type. But I'm trying to create a generic application, so the Text type should work ...

Would it be possible for SQL Server to convert Text to VARCHAR if it has a length? Or is there a better way of handling this?

[Former user]

In addition, the text type on SQL Server cannot compare items with an equals to (=) operator...

[Mike Bayer]

if you have a length, you should generally use String(), not Text(). We have done some automatic "switching" of these types in the past based on length present or not (the reverse of this case, actually) but that's no longer the current practice.

The documentation for Text doesn't seem to make this clear enough, that it's generally the "unlengthed" type, if the user were not familiar with the CLOB and TEXT types.

[Former user]

Added a couple sentences to documenation - Toby

[Mike Bayer]

5f51d409ccda1033a41256dfc28e46bc6923521d