Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4114) similar to does not match x'##'-codes

Am 07.06.2013 17:55, schrieb Dimitry Sibiryakov: 07.06.2013 17:31, Leyne, Sean wrote: If an operator is comparing OCTETS against a string value, OCTETS value should be coerced into the charset of the other value. In which way? How code x'a0' should be coerced into UTF-8? As

[Firebird-devel] [FB-Tracker] Created: (CORE-4114) similar to does not match x'##'-codes

similar to does not match x'##'-codes - Key: CORE-4114 URL: http://tracker.firebirdsql.org/browse/CORE-4114 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 2.5.2

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4114) similar to does not match x'##'-codes

similar to does not match x'##'-codes - Key: CORE-4114 URL: http://tracker.firebirdsql.org/browse/CORE-4114 Project: Firebird Core Issue Type: Bug Components: Engine Affects

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4114) similar to does not match x'##'-codes

On Fri, 7 Jun 2013 10:56:43 -0400, Leyne, Sean s...@broadviewsoftware.com wrote: similar to does not match x'##'-codes - Key: CORE-4114 URL: http://tracker.firebirdsql.org/browse/CORE-4114 Project: Firebird

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4114) similar to does not match x'##'-codes

As this example points out, x'##'-codes are not properly matched by similar to: select iif(' ' similar to '[[:WHITESPACE:]]', 'T', 'F'), iif(x'20' similar to '[[:WHITESPACE:]]', 'T', 'F'), iif(x'20' similar to '%', 'T', 'F') from RDB$DATABASE returns 'T', 'F', 'F' I

Re: [Firebird-devel] [FB-Tracker] Created: (CORE-4114) similar to does not match x'##'-codes

On 07/06/2013 11:56, Leyne, Sean wrote: similar to does not match x'##'-codes - Key: CORE-4114 URL: http://tracker.firebirdsql.org/browse/CORE-4114 Project: Firebird Core Issue Type: Bug