Special character in DQL Insert Statement

Hello All,

In one of our server method we are inserting records into Register table. One of the Column is Name.Some times we retrive name from database as O'Harry ,

D' Ologla. Insert statement fails if a name has apostrophe . Can we insert records into register table with apostrophe ? Is there any key word in dql to accept specail characters? I tried using '\' before specail character it did not work. Please, let know if any key word needs to be used to avoid failure while inserting into register table. Example will of great help.

Thanks in Advance.

Marada.

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

Hartmut Clausen

An apostrophe in a string can be escaped with another apostrophe, e. g. Update dm_dbo.my_table set my_attr = 'O''Hara'

All comments

Hartmut Clausen

An apostrophe in a string can be escaped with another apostrophe, e. g. Update dm_dbo.my_table set my_attr = 'O''Hara'

stephanemarcon

Hi,

Use the ESCAPE keyword, like described in the DQL refenrence guide. You may have a look at the following thread which lists the corresponding section and provides someexample: https://community.emc.com/message/548314#548314

Stephane

sinhvt

Hello all,

I'm facing the same problems with other special characters, eg ( ) in the insert statement. How can I escape them?

Thanks in advanced!

mssiva86

Hi Sinhvt,

As long as you give the special character like (,) inside the single quotes as a string value, you don't need to give escape sequence character.

regards

Siva.

sinhvt

Thanks for your reply. Finally, the problems came with the apostrophes inside string values.