On Wed, 1 Oct 2003 10:36, Dimitri Maziuk wrote:
> I'm trying to use text tables and I ran into a problem with values
> that contain newlines: HSQLDB will happily write multi-line value out
> to CSV file, and then it'd treat newlines as record separators.
I have no experience with writing text files using HSQLDB, but
> Am I missing something obvious? I don't see a way to specify record
> separator for text tables -- can I store multi-line strings in text
HSQLDB seems to recognise java escape codes, so \n in a string is a=20
newline eg in the following line from one of my tables the (single line=20
in the file):
(1500m);","One lump of coal - 200g.\nConsiderable amounts of fish etc "
the last column is:
"One lump of coal - 200g.\nConsiderable amounts of fish etc "
Which is treated as two lines:=20
One lump of coal - 200g.
Considerable amounts of fish etc=20
CSIRO Marine Research
During the past 30 years people from all the civilised
countries of the earth have consulted me.
Among all of my patients in the second half of life,=20
that is to say, over 35, there has not been one whose
problem in the last resort, was not that of finding a=20
religious outlook on life.
- Carl Justav Jung, one of the great founders of psychology