Re: [Firebird-net-provider] Create Database Tables

[Jiří Č. <ji...@ci...>]

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