I am trying to store a HL7 message in a sqllite database.
If I do this, the message which should be stored is truncated on the position in the message where a space or a r occurs.
I tried to bypass this by defining the storage field as clob. That did not help.
How do I pursuade the insert sql to take the full message instead of just a part of it?
Example:
Create a table
CREATE TABLE MSGBUFFER (MSGID varchar, MSG clob)
Set MSGID
Set MSG is
Try to save the message:
INSERT INTO MSGBUFFER VALUES (‘$MSGID’, ‘$MSG’)
Wih this query only the MSH segment is stored in the MSG database-field.