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
-~----------~----~----~----~------~----~------~--~---
