https://community.sap.com/t5/technology-q-a/unicode-handling-for-ms-sql-oracle-database/qaa-p/12137568#M4536231 <P>Hi!</P><P>You could use additional single quote sign for that, like:</P><P>N'Some''s value'.</P><P>Regards, Evgeniy.</P> Thu, 19 Mar 2020 08:12:47 GMT former_member190293 2020-03-19T08:12:47Z https://community.sap.com/t5/technology-q-a/unicode-handling-for-ms-sql-oracle-database/qaq-p/12137567 <P>Hi,</P> <P>We have a scenario, where we possibly have unicode characters when sending data to MS Sql server via JDBC. We handle this requirement by implementing what is suggested in note 831162 (Question No 27). So we apply the N'Some Value' method.</P> <P>The problem now is, some time it is possible to have ' inside the value. Such as "<EM>Some's Value</EM>". In this case, error will occur saying "Incorrect Syntax near s". How to overcome this issue?</P> <P>Thank you.</P> Thu, 19 Mar 2020 05:33:05 GMT https://community.sap.com/t5/technology-q-a/unicode-handling-for-ms-sql-oracle-database/qaq-p/12137567 suwandi_cahyadi 2020-03-19T05:33:05Z https://community.sap.com/t5/technology-q-a/unicode-handling-for-ms-sql-oracle-database/qaa-p/12137568#M4536231 <P>Hi!</P><P>You could use additional single quote sign for that, like:</P><P>N'Some''s value'.</P><P>Regards, Evgeniy.</P> Thu, 19 Mar 2020 08:12:47 GMT https://community.sap.com/t5/technology-q-a/unicode-handling-for-ms-sql-oracle-database/qaa-p/12137568#M4536231 former_member190293 2020-03-19T08:12:47Z