> 1) Is it correct to have multiple fbCmd.ExecuteNonQuery() commands ...
> followed by one fbTransaction.Commit()?

Yes. Also use `using` block for disposable resource.

> 2) I want to be able to handle German vowels, such as umlauts, for
> fstInfo.  I don't think VARCHAR is the correct choice as it is
> non-unicode.

You can use CHARACTER SET clause. Best is probably to use UTF8.
 
> 3) I also want variable lengths, without a max, for fstInfo.  What do
> I use in place of the "100"?

Then you have to use BLOB SUB_TYPE TEXT.

-- 
Mgr. Jiří Činčura
https://www.tabsoverspaces.com/

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider

Reply via email to