escape characters in CLOB values - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

escape characters in CLOB values

gunyogunyo Posts: 6Member
Yet another question...
Is there a way to store newlines, etc. in CLOB or varchar variables, like using
or in C++? Or must the whole CLOB be one long, long line?

Thx


Comments

  • infidelinfidel Posts: 2,900Member
    : Yet another question...
    : Is there a way to store newlines, etc. in CLOB or varchar variables, like using
    or in C++? Or must the whole CLOB be one long, long line?

    CLOBs and VARCHARs can contain any characters. You just have to be careful when using literal strings because the SQL parser isn't as intelligent as other string parsers.

    This statement inserts a newline-terminated string to a CLOB field:
    insert into myclobs (data) values 'foobar' || chr(10)

    Single quotes are special characters in SQL, so you need to escape them:
    insert into myclobs (data) values 'foobar''s home' || chr(10)

    Both of these statements should work equally well for CLOBs or VARCHARs.


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

Sign In or Register to comment.