First I want to say as someone new to the H2 database that I think you
did an outstanding job on both the quality and documentation of the
software.
I was able to install it and get up and running quickly. Performance
seems good.
The problem I am seeing is when I try to import csv data that contains
null chars in it. I recognize that I can fix the routine that writes
out the data to either drop chars less that 32 or replace them with
spaces but I am hoping that the code for CSVREAD could be changed to
treat the null char/s as an empty char value that is not null.
So a csv data null value would be || (put into the db as null) and |
char(0)| or |char(0)char(0) ... | would be put into the db as '' when
importing into a varchar column.
As a side note MS SQL Server handles the embedded nulls (imported as a
bulk import) by assigning an empty value of '', which is of course not
the same as NULL. It would be nice to be compatible with the CSV logic
that bulk import uses.
Here is an example (names, etc changed somewhat to protect the
client). The value of the ZIP data is char(0) which I don't think
should be entered into the db as null.
/* Table Drop and Create
--------------------------------------------------------------------
*/
DROP TABLE FOO.foo;
CREATE TABLE FOO.foo(
STREET varchar(25) NOT NULL,
STREETAD varchar(14) NOT NULL,
CITY varchar(24) NOT NULL,
ST varchar(2) NOT NULL,
ZIP varchar(5) NOT NULL,
PHONE varchar(11) NOT NULL
);
/* Import Data from flat file
--------------------------------------------------------------------
*/
INSERT INTO FOO.foo (STREET,STREETAD,CITY,ST,ZIP,PHONE) SELECT * FROM
CSVREAD('C:\temp\testdata\foo_foo.dat', 'STREET|STREETAD|CITY|ST|ZIP|
PHONE', 'UTF-8', '|', '\n');
then I get the following error
NULL not allowed for column "ZIP"; SQL statement:
Here is a hex dump of part of the csv data with nulls in it
20202020 20202020 7C202020 20207C4D | |M 000070
41207C00 00000000 00007C30 31202020 A |.......|01 000080
--
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.
