Hi, Currently, operations that involve char and varchar result in char. That's why the result of coalesce(char, varchar) is char.
I wonder, why do you use "char" and not "varchar"? Regards, Thomas On Mon, Nov 3, 2014 at 11:57 AM, Jiunn Jye Ng <[email protected] <javascript:_e(%7B%7D,'cvml','[email protected]');>> wrote: > Hi All, > > Let's say > white space = ' ' > empty string = '' > coalesce should return the first non null value. > > Test Case: > create table testCoalesce ( colvarchar varchar, colchar char); > insert into testCoalesce (colvarchar, colchar) values (' ', ' '); > > select coalesce(colvarchar, colchar), length(coalesce(colvarchar, > colchar)) from testCoalesce > return an empty string '' > > I understand that char does not store the trailing spaces. That explain > where the empty string come from. But the result should have been the white > space ' '. > > This can be simulated on h2 version 1.4.182. > > Thank you. > > Rgds, > jay > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
