Varchar(max) Supporting?

[Hardy]

I have EA 7.1 and work with data model. I set the target database to be SQL 2005, but I cannot choose varchar(max) data type as my column.

How shall I do it?

[«Midnight»]

I think you set a tagged value for this. Do a search of EA help for something of that sort. If you don't find it try searching the forum. I think I remember one of the Sparxians posting about how to do this.

[edit]Please see Juhi's post below for a workable solution to this issue.[/edit]

[operaman]

When adding the columns/attribute via the table properties -> Table Detail Tab -> Columns/Attributes dialogue you should be able to specify varchar as the Data Type for a new Attribute from the dropdownlist. Once varchar is selected, a "Length" textbox will show, where the maxlength of the varchar attribute can be specified.

You will have to enure that your (SQL Server 2005) target DBMS is specified before entering the Table Properties dialogue or else there won't be any Data Types to display in the drop down. Once you have specified the Target DB, any new table element that is added to a diagram will have that DBMS specified as the 'DB Version' for the new table.

[Hardy]

This is what I did:

Step 1 -- define new table:


Step 2 -- add new column:


I selected "varchar" as data type, but I have nowhere to input "max" in Length field.

[juhi]

To use varchar(max) in EA, Please goto EA Settings | Database Datatypes | choose SQL Server 2005 as your product | Add varchar(max) to the Datatype Textbox | Add varchar as common type | Save. Now the Datatype varchar(max) will displayed ikn your Table Attribute [ Datatype Combobox ] dialog box.

  Juhi
Sparx Systems Pty Ltd.
[email protected]