How to escape single quotes in Sybase

sql sybase
Pez Cuckow picture Pez Cuckow · Sep 21, 2012 · Viewed 23.7k times · Source

I come from MySQL and the below query doesn't work in Sybase. How should I escape single quotes?

UPDATE Animals SET NAME = 'Dog\'s friends' WHERE uid = 12

Answer

Pez Cuckow picture Pez Cuckow · Sep 21, 2012

If working with Sybase, having got used to MySQL which more database users have experience you may soon discover you are unable to escape single quotes with backslash in.

So how do you escape quotes in Sybase? In fact, in Sybase SQL the single quote acts as the escape character.

See below for an example UPDATE statement in both “languages”:

MySQL

UPDATE Animals SET NAME = 'Dog\'s friends' WHERE uid = 12

Sybase

UPDATE Animals SET NAME = 'Dog''s friends' WHERE uid = 12

I’m not entirely sure this makes sense to me (especially as it looks like a double quote) but there you go!

Related questions

Convert INT to VARCHAR SQL

I am using Sybase and I am doing a select which returns me a column called "iftype", but its type is int and I need to convert into varchar. When I try to do the select without the convert function …

Read More
Cannot insert explicit value for identity column in table 'table' when IDENTITY_INSERT is set to OFF

I have the below error when I execute the following script. What is the error about, and how it can be resolved? Insert table(OperationID,OpDescription,FilterID) values (20,'Hierachy Update',1) Error: Server: Msg 544, Level 16, State 1, Line 1 Cannot insert explicit value …

Read More
From a Sybase Database, how I can get table description ( field names and types)?

I have access to command line isql and I like to get Meta-Data of all the tables of a given database, possibly in a formatted file. How I can achieve that? Thanks.

Read More