2 # Attempt to put an event containing odd characters
5 URL=http://regression.host/caldav.php/User%20Six/home/c0f7c860-1345-012d-125f-002421a2359e.ics
7 HEADER=Content-Type: text/calendar; charset=utf-8
12 PRODID:-//Open Source Applications Foundation//NONSGML Chandler Server//E
17 TZID:America/Los_Angeles
18 X-TZINFO:America/Los_Angeles[2007g/Partial@883612800000]
22 TZNAME:America/Los_Angeles(DST)
23 DTSTART:19980405T020000
24 RRULE:FREQ=YEARLY;UNTIL=20060403T100000Z;BYMONTH=4;BYDAY=1SU
29 TZNAME:America/Los_Angeles(STD)
30 DTSTART:19981025T020000
31 RRULE:FREQ=YEARLY;UNTIL=20061030T100000Z;BYMONTH=10;BYDAY=-1SU
36 TZNAME:America/Los_Angeles(DST)
37 DTSTART:20070311T020000
38 RRULE:FREQ=YEARLY;BYMONTH=3;BYDAY=2SU
43 TZNAME:America/Los_Angeles(STD)
44 DTSTART:20071104T020000
45 RRULE:FREQ=YEARLY;BYMONTH=11;BYDAY=1SU
49 LAST-MODIFIED:20100316T162103Z
51 UID:c0f7c860-1345-012d-125f-002421a2359e
52 SUMMARY:2nd Annual Lobsterfest: will you come?
53 DESCRIPTION:2nd Annual Lobsterfest\nSaturday\, August 7\nTime to be annou
54 nced\, @Chamisal Vineyards @1pm\n$85 members\; $100 non members. Inquire for s
55 pecial group pricing. Will you come?
56 DTSTART;TZID=America/Los_Angeles:20100807T000000
57 CREATED:20100316T162026Z
58 DTSTAMP:20100316T162103Z
60 LOCATION:Chamisal Vineyards\\, Oregon
61 X-VENUE:Chamisal Vineyards
67 SELECT caldav_data.caldav_data AS "Event Data", caldav_data.dav_name, caldav_data.dav_etag, dtstart, summary, description
68 FROM caldav_data JOIN calendar_item USING(dav_name)
69 WHERE caldav_data.dav_name ~ 'c0f7c860-1345-012d-125f-002421a2359e.ics'