Unicode Handling for MS Sql / Oracle Database

[#1]

Hi,

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.

The problem now is, some time it is possible to have ' inside the value. Such as "Some's Value". In this case, error will occur saying "Incorrect Syntax near s". How to overcome this issue?

Thank you.

[former_member190293 · Accepted solution]

Hi!

You could use additional single quote sign for that, like:

N'Some''s value'.

Regards, Evgeniy.