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 Cloud Platform 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 ONE Support launchpad (Login required).

Search for additional results

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