Re: [Firebird-devel] Created: (CORE-4201) computed field has null value inside BI trigger

2013-08-31 Thread Dmitry Yemanov
01.09.2013 06:29, Ann Harrison wrote: > I think this is correct - if unexplicable - behavior according to the > Standard. Something about the state of the column prior to the operation. I respectfully disagree. The NEW context is in the perfectly valid state in the BEFORE INSERT triggers. If y

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4201) computed field has null value inside BI trigger

2013-08-31 Thread Ann Harrison
I think this is correct - if unexplicable - behavior according to the Standard. Something about the state of the coulmn prior to the operation. On Aug 31, 2013, at 8:13 AM, "Gorynich (JIRA)" wrote: > computed field has null value inside BI trigger > ---

Re: [Firebird-devel] Unicode UTF-16 etc

2013-08-31 Thread Ann Harrison
On Aug 31, 2013, at 4:55 AM, Mark Rotteveel wrote: > On 29-8-2013 17:41, Jim Starkey wrote: >> Paradoxically, Japanese strings tend to be shorter in UTF-8 than 16 bit >> Unicode. The reason is simple: There are enough single byte characters >> -- punctuation, control characters, and digits --

[Firebird-devel] [FB-Tracker] Created: (CORE-4201) computed field has null value inside BI trigger

2013-08-31 Thread Gorynich (JIRA)
computed field has null value inside BI trigger --- Key: CORE-4201 URL: http://tracker.firebirdsql.org/browse/CORE-4201 Project: Firebird Core Issue Type: Bug Components: Engine Affec

Re: [Firebird-devel] Unicode UTF-16 etc

2013-08-31 Thread Dimitry Sibiryakov
31.08.2013 13:53, Mark Rotteveel wrote: > On 31-8-2013 13:38, Dimitry Sibiryakov wrote: >> 31.08.2013 13:29, Mark Rotteveel wrote: >>> As most languages don't need those surrogate pairs for their >>> codepoints/glyphs, it is easier to consider UTF-16 to be 2 byte. As far >>> as I know this is how m

Re: [Firebird-devel] Unicode UTF-16 etc

2013-08-31 Thread Mark Rotteveel
On 31-8-2013 13:38, Dimitry Sibiryakov wrote: > 31.08.2013 13:29, Mark Rotteveel wrote: >> As most languages don't need those surrogate pairs for their >> codepoints/glyphs, it is easier to consider UTF-16 to be 2 byte. As far >> as I know this is how most UTF-16 implementations handle it. > >

Re: [Firebird-devel] Unicode UTF-16 etc

2013-08-31 Thread Dimitry Sibiryakov
31.08.2013 13:29, Mark Rotteveel wrote: > As most languages don't need those surrogate pairs for their > codepoints/glyphs, it is easier to consider UTF-16 to be 2 byte. As far > as I know this is how most UTF-16 implementations handle it. In this case UTF-16 has no difference from UCS2. --

Re: [Firebird-devel] Unicode UTF-16 etc

2013-08-31 Thread Mark Rotteveel
On 31-8-2013 13:15, Dimitry Sibiryakov wrote: > 31.08.2013 10:55, Mark Rotteveel wrote: >> I'd prefer to have an option to use UTF-16 (treated as a 2-byte >> character set with surrogate pairs) as that will only halve the maximum >> allowed number of characters. > > Nope. If you take into accou

Re: [Firebird-devel] Unicode UTF-16 etc

2013-08-31 Thread Dimitry Sibiryakov
31.08.2013 10:55, Mark Rotteveel wrote: > I'd prefer to have an option to use UTF-16 (treated as a 2-byte > character set with surrogate pairs) as that will only halve the maximum > allowed number of characters. Nope. If you take into account surrogates, UTF-16 will have the same maximum of 4

Re: [Firebird-devel] Unicode UTF-16 etc

2013-08-31 Thread Mark Rotteveel
On 29-8-2013 17:41, Jim Starkey wrote: > Paradoxically, Japanese strings tend to be shorter in UTF-8 than 16 bit > Unicode. The reason is simple: There are enough single byte characters > -- punctuation, control characters, and digits -- stay as single bytes, > double byte characters are a wash, a

Re: [Firebird-devel] Fwd: Created: (CORE-4191) Define sequence name for "Identity Column Type"

2013-08-31 Thread Mark Rotteveel
On 27-8-2013 20:12, Adriano dos Santos Fernandes wrote: > On 27/08/2013 15:06, Leyne, Sean wrote: >> > I think an USING clause would be a great addition: > > GENERATED BY DEFAULT AS IDENTITY [USING SEQUENCE ] > > What do you think? What Sequence (name) would be used if the

[Firebird-devel] [FB-Tracker] Created: (CORE-4200) An uncommitted select of the new pseudo table sec$users (CORE-2639) seems to block new database connections

2013-08-31 Thread Robert (JIRA)
An uncommitted select of the new pseudo table sec$users (CORE-2639) seems to block new database connections --- Key: CORE-4200 URL: http://tracker.firebirdsql.