This is simple example

I using h2-1.3.166.jar

when I double-clicked the jar, the page for login will be opened on my
browser.

Following are login information
Saved Settings: Generic H2 Server
Setting Name: Generic H2 Server
Driver Class: org.h2.Driver
JDBC URL: jdbc:h2:~/Test
User Name: user
Password: password

When I clicked "Connect", the Test database will be created and goto
Test database

I created new table using sample sql like this
>> CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255));

Then, insert new row by using sample sql like this
>> NSERT INTO TEST VALUES(1, '');

Next, query TEST table by
>> SELECT * FROM TEST

and clicked "Edit" button and click to edit the row. I found that the
value in Name column that I inserted empty string into are a space,
not empty string.

Above example is simple case that I found my empty string value is
replaced with space

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

Reply via email to