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!
