From: Falkner P. <PET...@fj...> - 2004-03-30 07:24:59
|
Hello , my name is Peter and I use HSQL-Database for my Java based application. Now I have the problem with great textareas in which I have some carriage return linefeed- orders. I would like to storage these textareas with his carriage return commanders in the hsql-database. But I do not know how I can make this. I tried it to make with following command for example '<string1>''0x0d'0x0a''<string2>'. In DB2 database the command must be: 'String1'||chr(13)||chr(10||'String2'. In DB2 database it make the right function, but not in HSQL. It would be very nice if you can help me to solve this problem. Thank you Best regards Peter |