topic sql syntax error because of unicode character in Application Development and Automation Discussions

sql syntax error because of unicode character

Former Member — Fri, 26 Aug 2016 08:51:06 GMT

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

Re: sql syntax error because of unicode character

retired_member — Fri, 26 Aug 2016 09:20:27 GMT

Could you supply a real code example?

Re: sql syntax error because of unicode character

Former Member — Fri, 26 Aug 2016 11:11:06 GMT

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

Re: sql syntax error because of unicode character

retired_member — Fri, 26 Aug 2016 11:31:22 GMT

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?

Re: sql syntax error because of unicode character

Sandra_Rossi — Fri, 26 Aug 2016 11:42:41 GMT

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

Re: sql syntax error because of unicode character

retired_member — Fri, 26 Aug 2016 11:51:46 GMT

-> seems to be a surrogate

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

Re: sql syntax error because of unicode character

SuhaSaha — Fri, 26 Aug 2016 12:09:51 GMT

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

I remember your hotline comment