> Could you please let me know the best fit data type in XML in firebird,
> as firebird doesn't support the xml data type?
>
>
>
> I need the alternative data type of it.

If it's just about storing text (XML), then use BLOB SUB_TYPE 1.


--
With regards,
Thomas Steinmaurer

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/