Truncated Unicode fields in IDC/HTX pages

Hi,

I found that Unicode fields are truncated to 40 characters when inserted in
a HTX page. I made the tests with SQL 7 and SQL 2000 on the same machine as
IIS. This behaviour is present in IIS 4 and 5.
If I convert the field to ANSI with CAST or CONVERT then the field is
inserted with full length.

I'd like to know who is responsible for this behaviour (SQL Server,
httpodbc.dll or IIS), where the 40 come from (it's a setting ?) and, of
course, how to get rid of the limitation.

Thanks,

--
Eduard Ungureanu
A-E Electronics
eduardu@aee.ro