Hi,

> Could you please let me know the data type in Firebird which we are
> using in SQL varchar(Max).

I suggest BLOB, SUB_TYPE TEXT if you need to store truely large
quantities of text.

If your requirement is to store smaller strings, use something smaller.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!