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
Post a Comment