插入特殊字符 [英] Inserting special characters
问题描述
我想在Cassandra表中插入特殊字符,但我无法插入。
无法使用umlaut在表中插入数据
如上所述我尝试上面的链接,即使我的字符集是UTF8如上所述。我不能插入。我尝试使用引号仍然没有工作
CREATE TABLE test.calendar(
race_id int,
race_start_date timestamp
race_end_date timestamp
race_name text
PRIMARY KEY(race_id,race_start_date,race_end_date)
)WITH CLUSTERING ORDER BY(race_start_date ASC,race_end_date ASC
insert into test.calendar(race_id,race_start_date,race_end_date,race_name)values(501,2016-02-18 05:00:00 + 0000,2016-02-22 05:00: SyntaxException:< ErrorMessage code = 2000 [CQL查询中的语法错误] message =line 1:00 + 0000,'Hotel in derNähevon mir');
错误消息:
99不匹配输入'-02'expecting')'(... race_name)values(501,2016 [-02] -18 ...)>
您没有列出日期值, code> 2016-02-22 05:00:00 + 0000 被视为2016减02减22 blah blah blah - 算术运算后面跟随一些随机数字垃圾。 p>
尝试
INSERT .... VALUES -02-22 05:00:00 + 0000',...)
^ ------------------------ ^
。请注意'
引号。
I'm trying to insert special characters in my Cassandra table but I couldn't insert it. Inserting data in table with umlaut is not possible As mentioned in the link i tried above link even though my character set is UTF8 as mentioned.I'm not able to insert. I've tried using quotes also still didn't work
CREATE TABLE test.calendar (
race_id int,
race_start_date timestamp,
race_end_date timestamp,
race_name text,
PRIMARY KEY (race_id, race_start_date, race_end_date)
) WITH CLUSTERING ORDER BY (race_start_date ASC, race_end_date ASC
insert into test.calendar (race_id, race_start_date , race_end_date , race_name ) values (501,2016-02-18 05:00:00+0000 ,2016-02-22 05:00:00+0000 ,'Hotel in der Nähe von mir');
ERROR MESSAGE :
SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query] message="line 1:99 mismatched input '-02' expecting ')' (...race_name ) values (501,2016[-02]-18...)">
You didn't quote your date values, so 2016-02-22 05:00:00+0000
is seen as "2016 minus 02 minus 22 blah blah blah" - an arithmetic operation followed by some random numerical garbage.
Try
INSERT .... VALUES(... '2016-02-22 05:00:00+0000', ...)
^------------------------^
instead. Note the '
quotes.
这篇关于插入特殊字符的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!