Highlighted
Trusted Contributor.
Trusted Contributor.
316 views

Changing htmltemplates table expression field

1.SQL type VARCHAR(4000bytes)→Change to TEXT type Is this possible? Is default 4000bytes?

2.Will this be supported?

・In dbdict, open htmltemplates table.
・In SQL table tab add following.
  Alias:m2
  Name:HTMLTEMPLATESSM2
  Type:sqlserver
・From field tab choose expression.
Change to TEXT from VARCHAR(4000) in SQL type.
Change SQL table to m2

 

 

 

 

0 Likes
3 Replies
Highlighted
Absent Member.. Absent Member..
Absent Member..

Re: Changing htmltemplates table expression field

Use VARCHAR(MAX) - then you get the SQL version limitation - I think it's 8000 and that should be sufficient.

0 Likes
Highlighted
Trusted Contributor.
Trusted Contributor.

Re: Changing htmltemplates table expression field

Thank you for the reply.

Instead of changing it to TEXT from VARCHAR, its better to maximize to 8000?

If it is changed to TEXT, Will it be supported?

 

Akira

0 Likes
Highlighted
Trusted Contributor.
Trusted Contributor.

Re: Changing htmltemplates table expression field

 Hi,

 

I haven't encountered any officially described limitations for field size changing and as a result the loss of support.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.