What is the Confluence 5 SQL BODYCONTENT BODY Field Type?

[Richard Yale]

We are migrating from Confluence 3.5 using the Bob Swift Wiki Macro but the 3.5 BODY field type is nText and we are wondering what the BODY field type of Confluence 5 BODY field is. Is it still nText or is it varchar?

Thanks.

[Davin Studer · Accepted solution]

It is ntext.

[Richard Yale]

Atlassian, is there any plans to update the database to non-depreciated types?

[Davin Studer]

Agreed. It was depricated in 2005. So, it probably won't be there much longer. Atlassian will probably get around to changing it when it is actually removed from SQL Server.