Carriage return in a blob-field

E

elmasacretum

New Member
Hi,
I'm trying to insert data from a progress program to an external database.
The field I'm refering has a BLOB type. But it seems that the Carriage Returns are not accepted. (the external DB works with sql).

I've tried CHR(10) , \r and \x0d but nothing seems to work.
(The blob field shows an | when I use CHR(10) ).

Could anyone help me with this problem?
thnx
 
Have you tried "~n" (new line) or a combination of CR and NL (to make it a cariage return; line feed)?

What OS is this sql database on and what sort/brand sql database are you talking about?
 
jongpau said:
Have you tried "~n" (new line) or a combination of CR and NL (to make it a cariage return; line feed)?

What OS is this sql database on and what sort/brand sql database are you talking about?
Click to expand...

The OS is windows 2000, the database has a .GDB extension

("~n" didn't work either, thnx anyway)
 
From what I can find, a database with a gdb extension is *probably* an Interbase database (Borland??). I tried to find more info about the cr, but could not this morning, maybe searching the net a little might help?

Either Progress, or the ODBC driver you may be using to access the Interbase db, or the DB itself is stuffing you up somewhere down the track...
 
jongpau said:
From what I can find, a database with a gdb extension is *probably* an Interbase database (Borland??). I tried to find more info about the cr, but could not this morning, maybe searching the net a little might help?

Either Progress, or the ODBC driver you may be using to access the Interbase db, or the DB itself is stuffing you up somewhere down the track...
Click to expand...

Indeed, the DB-version is Interbase 6.5.
The program language of the program that uses this DB seems to be Delphi,
which I've got no experiece with whatsoever.
thnx for searching :).
 
Didn't work either, I've tried this :

control = 'test' + "\x0D\x0A" + 'test2' + "X0D\X0A" + 'test3'.

and this is the ouput :

test\x0D\x0Atest2X0D\X0Atest3
 
SQL Carriage Return in a Host language

In SQL, the carriage return is coded by chr(13),
and the concatenation operator by || ...

But in your case, SQL is used as an "embedded language",
in the "Host language", you have to build a string which looks like :
control = " 'test' || chr(10) || 'test2' || chr(10) || 'test3' ".

I Think it will work...

Good Luck...
 
CLOB Vs BLOB...

Another suggestion...

You are using Binary data instead of Character data...
More explicitly : BLOB instead of CLOB

Try to modify your database schema...





 
You must log in or register to reply here.
Back
Top