I see two choices, neither of which I would implement without involving the vendor of the product, unless you own it.

One requires upgrading to SQL Server 2005/2008 and changing the column to NVARCHAR(MAX). The second would be to change the column in SQL Server 2000 to NTEXT, know that this is depreciated in SQL Server 2005 with the new VARCHAR(MAX), NVARCHAR(MAX), and VARBINARY(MAX) data types.