# Special characters in SQL Query in R2RML

**URL:** <https://community.stardog.com/t/special-characters-in-sql-query-in-r2rml/702>\
**Category:** Support\
**Created:** [November 21, 2017, 8:39am UTC](https://community.stardog.com/t/special-characters-in-sql-query-in-r2rml/702 "2017-11-21T08:39:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![PaulZH](https://avatars.discourse-cdn.com/v4/letter/p/f07891/32.png) [@PaulZH](https://community.stardog.com/u/PaulZH)\
**Post date:** [November 21, 2017, 8:39am UTC](https://community.stardog.com/t/special-characters-in-sql-query-in-r2rml/702/1 "2017-11-21T08:39:01Z")

</div>

Stardog server 5.0.5

jdbc.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver  
jdbc driver: sqljdbc42-6.0.8112.100.jar

Having in my R2RML Mapping in the SQL query (rr:sqlQuery “”" “”"; ) special characters

example 1: ~  
SELECT a.ObjectId, ~a.Officieus as officieelToegekend  
FROM [Adres] a

example 2: ^  
SELECT a.ObjectId, 1 ^ a.Officieus as officieelToegekend  
FROM [Adres] a

Both queries work outside of stardog.

In stardog:  
Unable to parse R2RML view query [[SELECT a.ObjectId, ~a.Officieus as officieelToegekend FROM [Adres] a]]: Lexical error at line 1, column x. Encountered: “~” (126), after : “”

Unable to parse R2RML view query [[SELECT a.ObjectId, 1 ^ a.Officieus as officieelToegekend FROM [Adres] ]]: Encountered “^” at line 1, column x.

Any special encoding or escaping to do?

---

<div class="post-metadata">

**Author:** ![PaulZH](https://avatars.discourse-cdn.com/v4/letter/p/f07891/32.png) [@PaulZH](https://community.stardog.com/u/PaulZH)\
**Post date:** [November 21, 2017, 12:07pm UTC](https://community.stardog.com/t/special-characters-in-sql-query-in-r2rml/702/2 "2017-11-21T12:07:17Z")

</div>

Meanwhile found a solution

`case Officieus WHEN 'true' THEN 'false' WHEN 'false' then 'true' END as officieelToegekend`

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex030/uploads/stardog/original/2X/e/ed66b48a616f505106a4acde3c9cee7e6da9bc67.svg) [@system](https://community.stardog.com/u/system)\
**Post date:** [December 5, 2017, 12:07pm UTC](https://community.stardog.com/t/special-characters-in-sql-query-in-r2rml/702/3 "2017-12-05T12:07:30Z")

</div>

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.