Couchbase N1QL: Updating fields containing single quotes, double quotes, orbackslash

SQL++
1

Hi,

I’m having trouble updating fields assigning them with string that contains single quotes, double quotes, or backslash.

Example:
UPDATE key-space USE KEYS ‘id’ SET description= "John’s words are “Never give up” "

I tried updating field with back ticks and it just unset the field

I’m using Coubhase Server 5.0

2 
UPDATE  default AS d USE KEYS  "k01" 
SET description= "John's words  are \"Never give up\". blackslash \\. ";
3

Hi @vsr1,

Thanks for your quick response. This works!

But, is there a built in function in N1QL where it will autamatically escape the quotation marks and backslashes?

4

Uou can’t void escape. strings must represent proper matching quotes

5 
UPDATE  default AS d USE KEYS  "k01" 
SET description= "John's words  are \"Never give up\". blackslash \\. ";

Will set the description as John’s words are \“Never give up\”. blackslash \.

What I need is to store it as John’s words are “Never give up”. blackslash \.

6

If you filed is string type it must have in the quotes. If string want to contain another quotes it must be escaped.
https://www.json.org/json-en.html

7

It’s clearer now. It is impossible to store string without escaping double quotes and backslash. This will be handled on our end. Thank you.

8

Encountered another problem when the backslash is on the end of string followed by another field to update

UPDATE  default AS d USE KEYS  "k01" 
SET description= "John's words  are \"Never give up\". blackslash \\", title="Title 1"
9

Workaround . MB-38481

UPDATE  default AS d USE KEYS  "k01" SET description= "John's words  are \"Never give up\". blackslash \\",
 title='Title 1' ;
10

As our update is dynamic, this will cause problem esp on consecutive fields to update with backlash at the end of string