Re: CQL: How to escape single quotes?

2011-08-04 Thread Eric Evans
On Wed, 2011-08-03 at 17:22 +0200, Jens Hartung wrote: Odd, when you generally escape special chars with an backslash. Not in SQL (which CQL is patterned after). SQL escapes single quotes using an additional quote character. -- Eric Evans eev...@rackspace.com

Re: CQL: How to escape single quotes?

2011-08-03 Thread Jens Hartung
Hi, thank's for your help. This does work. Odd, when you generally escape special chars with an backslash. Original-Nachricht Datum: Tue, 02 Aug 2011 21:42:44 -0500 Von: Eric Evans eev...@rackspace.com An: user@cassandra.apache.org Betreff: Re: CQL: How to escape single

CQL: How to escape single quotes?

2011-08-02 Thread Jens Hartung
Hi all, first, i'm new to Cassandra. I'm use Cassandra 0.8.2 with CQL JDBC Driver Version 1.0.3. My problem is, that I have to insert a large amount of weather data to Cassandra via JAVA. Some of the weather station have single quotes in their name. When I insert them directly via a

Re: CQL: How to escape single quotes?

2011-08-02 Thread Eric Evans
On Wed, 2011-08-03 at 03:58 +0200, Jens Hartung wrote: Is there a way, to insert Strings with single quotes to Cassandra via CQL? Yes, escape them with another single quote ('aa''bb'). -- Eric Evans eev...@rackspace.com