Hi all,



I am SLOWLY moving all my databases from Microsoft SQL to Firebird (because
firebird is SOOO Quick and Free and MORE stable then MSSQL)



Anyway I have a few questions



Question 1

In MSSQL I can use nvarchar(max)



What would that be in FireBird? I need to entry to beale to have the MAX
storage for it as possible (as it can store from 1 line to millions (as this
is used to handle the Journal entry of a checkin system and the customer
wants to keep the entrys for 6 years or more)



I hope someone can help me with this as this is THE ONLY problem I have at
the moment with Firebird (every other database moved over with no problem)
Just have to move the data over once I have this table sorted.





Question 2

Is there a quick way to import data from a MSSQL database to a FireBird
Database?







Thanks for your time with this





Andy




----------


No virus found in this outgoing message.
Checked by AVG - www.avg.com
Version: 9.0.851 / Virus Database: 271.1.1/3143 - Release Date: 09/18/10 07:34:00


[Non-text portions of this message have been removed]