cql - Inserting special characters in Cassandra -


hi trying insert following text cassandra using cql (cqlsh 3.0.2 | cassandra 1.2.5)

insert "mediacategory" ("mcategoryid", "submcategoryname", "photorankid",    "virtualtourid", "langid") values (14,'vue depuis l'hôtel',92002,192002, 1036); 

but when try doing error saying invalid syntax .basically unable unsert has "l'"

you can use double ' (i.e., '') represent ' in cql. example:

insert text_table (text_data) values ('vue depuis l''hôtel'); 

Comments

Popular posts from this blog

Detect support for Shoutcast ICY MP3 without navigator.userAgent in Firefox? -

web - SVG not rendering properly in Firefox -

java - JavaFX 2 slider labelFormatter not being used -