Subject RE: [firebird-support] What would this be in Firebird?
Author Andrew Gable
On the list I do not have 1 should I Select TEXT?

-----Original Message-----
[] On Behalf Of Thomas Steinmaurer
Sent: 19 September 2010 11:32 AM
Subject: Re: [firebird-support] What would this be in Firebird?


> I am SLOWLY moving all my databases from Microsoft SQL to Firebird
> 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)

If this is some sort of MEMO type, thus, allowing to store a huge number
of characters in a field, then you'd best use


in Firebird.

> 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
> 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?

Our product Database Workbench supports both DBMS engines and also
allows you to migrate data and metadata. Check it out:

Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
My blog:



Visit and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at

Yahoo! Groups Links


No virus found in this outgoing message.
Checked by AVG -
Version: 9.0.851 / Virus Database: 271.1.1/3145 - Release Date: 09/19/10 07:34:00

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