SAP Knowledge Base Article - Preview

2658013 - The escape sequence character '\' is displayed different in studio SQL console and HDBSQL

Symptom

When you insert word with escape sequence character like \ (backslash on english enviroment) to a table, escape sequence character was increased double in inside of table when you export this table or confirm from HDBSQL.

Export result:

6.18.1.png

HDBSQL result:
6.18.2.png

But if you check from HANA studio SQL console, the value of escape sequence character '\' will as same result as inserted.

6.18.3.png


Read more...

Environment

  • SAP HANA database 1.0
  • SAP HANA database 2.0

Product

SAP BTP, Neo environment 1.0

Keywords

 Escape sequence character, HDBSQL, SQL Console , KBA , HAN-DB-ENG , SAP HANA DB Engines , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.