Re: [firebird-support] What is more effective execute block or select?

On Wed, Jan 27, 2016 at 7:48 AM, hamacker sirhamac...@gmail.com [firebird-support] wrote: > > > I would know whats methods is more effective, per exemple: > Example below shows two convoluted ways to return 'Y' or 'N' depending on whether an item with a

Re: [firebird-support] cannot transliterate Firebird 1.5

Is there any utf-8 code page that can be used as database charset? So, there will be possibly no more such issues. Sent from my iPhone > On 27 Jan 2016, at 15:25, Dimitry Sibiryakov s...@ibphoenix.com > [firebird-support] wrote: > > 27.01.2016 14:15,

Re: [firebird-support] What is more effective execute block or select?

>If the question is which is likely to perform better, then the answer is the select. >Select statements can be compiled and optimized once and reused, avoiding >validating access and metadata references. The execute block must be compiled, >optimized, and access checked each time it's

Re: [firebird-support] What is more effective execute block or select?

On Wed, 27 Jan 2016 10:48:49 -0200, "hamacker sirhamac...@gmail.com [firebird-support]" wrote: > I would know whats methods is more effective, per exemple: > To know if itens exists or not, select: > select > case > when exists(select 1 from cv_itens where

Re: [firebird-support] cannot transliterate Firebird 1.5

On 27/01/2016 13:15, blumy2...@yahoo.com [firebird-support] wrote: in my Builder c++ 6 application i have a SQL query for a table, in Firebird 1.5.6 fdb database " where STRADA " + = QuotedStr(edText->Text). Field STRADA in table is define WIN1251 in edText, the are Romanian characters,

Re: [firebird-support] cannot transliterate Firebird 1.5

27.01.2016 14:15, blumy2...@yahoo.com [firebird-support] wrote: > Field STRADA in table is define WIN1251 Win1251 is a Cyrillic character set, it dos not include Romanian letters. -- WBR, SD.

[firebird-support] What is more effective execute block or select?

I would know whats methods is more effective, per exemple: To know if itens exists or not, select: select case when exists(select 1 from cv_itens where id_cv=51716) then 'Y' else 'N' end as existe_itens from rdb$database OR using block execute: execute block returns(exist

[firebird-support] cannot transliterate Firebird 1.5

in my Builder c++ 6 application i have a SQL query for a table, in Firebird 1.5.6 fdb database " where STRADA " + = QuotedStr(edText->Text). Field STRADA in table is define WIN1251 in edText, the are Romanian characters, like ş and ţ. if the text not include romanian characters,