Hi,
> Is the behavior of H2 a problem for you? If yes why?
>
If possible, My application would not like to
care whether the data is extracted from Oracle DB
directly or through LinkedTable object for the table.
I would like to hide data source from application by
DAO pattern.
So, it's undesirable that there are differences between
the data extracted directly from DB and LinkedTable.
Sincerely,
On Sep 22, 1:30 pm, "Thomas Mueller" <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> > you get value 'A ' in native JDBC access(Oracle / SQLServer
> > etc...)
>
> Yes, you also get that in Derby. However you don't in PostgreSQL,
> MySQL, HSQLDB, and H2. Example:
>
> create table test(name char(15));
> insert into test values('Hello');
> select length(name), name from test;
> MySQL, PostgreSQL, HSQLDB, H2:
> <5> <Hello>
>
> Derby, Oracle:
> <15> <Hello >
>
> SQLServer (select len(name), name from test):
> <5> <Hello >
>
> > So, the H2 CHAR Type definition("ignores trailing spaces") seems
> > inconsistent with other RDBMSs.
> > I would like to ask you why H2 CHAR Type is desigined like above.
>
> Mainly because of PostgreSQL and MySQL.
>
> Is the behavior of H2 a problem for you? If yes why?
>
> Regards,
> Thomas
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
