On Thu, Sep 14, 2017 at 10:02 PM, iostream wrote:
> I have used Informix DB before. In Informix string comparisons such as -
>
> SELECT * from Person where fName = "ABC";
>
> return rows even if the column value has trailing spaces. The Informix
> engine internally trims strings before comparison
I have used Informix DB before. In Informix string comparisons such as -
SELECT * from Person where fName = "ABC";
return rows even if the column value has trailing spaces. The Informix
engine internally trims strings before comparison. It would be great if a
similar feature could be added to Ig
On Thu, Sep 14, 2017 at 7:10 PM, iostream wrote:
>
> 1. Whether Ignite does not TRIM strings internally when doing comparisons?
>
I don't think Ignite trims strings for comparison. You should use TRIM()
function explicitly when inserting or comparing strings.
> 2. Is there a way to configure m
Hi,
I am trying to fetch records from my cache based on the value of a column
which is a STRING datatype.
My string column has a few trailing spaces as such - "ABC".
When I use the below SQL statement -
SELECT * from Person where fNmae = "ABC";
I find no matches. However, when I use the bel