Escape double quote in sybase

2019-09-05 04:03发布

问题:

I am running a query on a database to retrieve records in a CSV (with quotes) format:

"Data","More data","some "funny" data with quotes","more".

Now when this is parsed, there is an obvious problem with this bit:

...,"some "funny" data with quotes",...

Is there a way to "escape" these quotes in sybase to save me post-processing?

回答1:

if it's just double-quote you want to select in a literal string, use single quote as the string's delimiter.

Try select '"' and you'll see



回答2:

--after you execute this sentence: SET QUOTED_IDENTIFIER ON

--you will be able to execute: select count(*) from "/table/name" go