[h2] Planned change: add option to not trim fixed length character fields

2016-05-18 Thread Peter Becker
Hi all, we are running into an issue with H2's behaviour around fixed length character types as described in https://groups.google.com/forum/#!topic/h2-database/oB3Wrv0obEQ The situation we have is that we are writing tests for an abstraction layer on top of JD Edwards, which uses CHAR fields

Re: [h2] Planned change: add option to not trim fixed length character fields

2016-05-23 Thread Peter Becker
mode that will not do it after the change, then it will break. Peter On Friday, May 20, 2016 at 6:24:53 PM UTC+10, Noel Grandin wrote: > > > > On 2016/05/19 5:39 AM, Peter Becker wrote: > > > > I looked at how I could possibly fix this. The relevant code seems to

Re: [h2] Planned change: add option to not trim fixed length character fields

2016-05-25 Thread Peter Becker
Hi Noel, I tried this for a bit, but it's difficult. The two issues I am currently facing are: * a common path to org.h2.value.ValueStringFixed#get() seems to be via org.h2.value.Value#convertTo(int), which doesn't have access to the mode * to do things in the DB2 way I will also have to have

Re: [h2] Planned change: add option to not trim fixed length character fields

2016-06-01 Thread Peter Becker
pull request if needed, or for you to just apply the change on your own. Cheers, Peter On Thursday, May 26, 2016 at 5:25:30 PM UTC+10, Noel Grandin wrote: > > > On 26 May 2016 at 02:35, Peter Becker > > wrote: > >> >> I tried this for a bit, but it's dif

[h2] Using PgServer with MSSQL compatibility

2016-10-12 Thread Peter Becker
Hello all, we are trying to do something a bit more unusual: use the PostgreSQL wire protocol to talk to H2 as if it is a SQL Server. The reason behind that is that we are migrating from PHP to Java and want to run integration tests on top of H2. PHP seems to be capable of connecting to H2's Pg

[h2] Re: Using PgServer with MSSQL compatibility

2016-10-12 Thread Peter Becker
3:43:21 PM UTC+10, Peter Becker wrote: > > Hello all, > > we are trying to do something a bit more unusual: use the PostgreSQL wire > protocol to talk to H2 as if it is a SQL Server. The reason behind that is > that we are migrating from PHP to Java and want to run integratio

[h2] Re: Using PgServer with MSSQL compatibility

2016-10-12 Thread Peter Becker
Peter On Thursday, October 13, 2016 at 3:59:01 PM UTC+10, Peter Becker wrote: > > Sorry - I just realized there is > https://groups.google.com/forum/#!topic/h2-database/bg_dGVT_XbA already. > > Given how quiet that has been I assume the feature doesn't exist. Can > anyo

Re: [h2] Re: Using PgServer with MSSQL compatibility

2016-10-13 Thread Peter Becker
utter madness, but for our testing needs it's perfect. Peter On Thursday, October 13, 2016 at 9:08:48 PM UTC+10, Sergi Vladykin wrote: > > I guess this option must be a part of database URL. > > Sergi > > 2016-10-13 9:20 GMT+03:00 Peter Becker > >: > >>