sql syntax error because of unicode character

[Former Member]

Hi forum,

I stumbled over a strange behavior when executing a SQL query where a specific character is part of.

Whenever I use    ( 25E81 from CJK Ideograph Extension B ) in any query, it throws an 'sql syntax error: incorrect syntax near ....'

If I remove the character, everything is fine.

This error is also occurring when SQL Editor of DBACOCKPIT.

Does someone know how to resolve this ?

Regards

Volker

[retired_member]

Could you supply a real code example?

[Former Member]

Hi Horst, this is example where it fails.

data:

con type ref to CL_SQL_CONNECTION,

stmt type ref to CL_SQL_STATEMENT.

con = cl_sql_connection=>get_connection( 'DBCON' ).

stmt = con->create_statement( ).

stmt_txt =  'select ''  '' from DUMMY'.

stmt->execute_update( stmt_txt ).

Unfortunately I cannot put this characters into this thread. You need to replace the blank with the character.

Regards Volker

[retired_member]

Uh-huh. So it is Native SQL via ADBC.

While I still don't see how I can connect the above code snippet to your problem (cause it runs for me after replacing literal 'DBCON' with a real connection and I don't see what character you are talking about), I tend to say that it is not an ABAP but a DB problem.

But maybe one other thing: ABAP supports UCS-2 characters only, that is UTF16 without surrogates. Is the character in question a surrogate?

[Sandra_Rossi]

Character U+25E81 ? http://www.fileformat.info/info/unicode/char/25e81/index.htm

[retired_member]

-> seems to be a surrogate

(have to ask a DBI guy who is not in the office today)

[SuhaSaha]

(have to ask a DBI guy who is not in the office today)

I remember your hotline comment