1) It's not obvious to me where to put the 'using' with 'try'. Could you provide an example using the code in my first email?
2) Is this what you recommend? where stSql = "CREATE TABLE TableOrg ( fstPriority VARCHAR(10), fstInfo VARCHAR(x) CHARACTER SET UNICODE_FSS, fiKeyID INTEGER PRIMARY KEY )". What do I use for 'x'? This should be variable. 3) BLOB SUB_TYPE TEXT is non-Unicode. The field 'fstInfo' needs to handle German. On Thu, Mar 23, 2017 at 2:11 AM, Jiří Činčura <j...@cincura.net> wrote: >> 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 ------------------------------------------------------------------------------ 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
