Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Adam Naylor <Adam dot Naylor at mail dot sema dot co dot uk>
Subject: RE: single quotes in text datatypes
Date: Apr 16 1998 4:15PM


The secret is to do something like this:

dbproc->dbcmd("The quick brown fox jumps over the lazy dog's tail.");

This should work without resorting to DBSAFESTR.

Gets interesting if you want both quotes in a string, though!


Adam Naylor

> ----------
> From: 	David Carter
> Sent: 	16 April 1998 15:47
> To:
> Subject: 	single quotes in text datatypes
> Hi,
> Hope this is an easy one for my first posting:
> How do I insert a TEXT datatype containing a '?
> Read the FAQ, but didn't find a satisfactory solution (the description for
> dbsafestr seems to imply that it will convert ' to "). It's not correct to
> say `David"s book`. Besides - it looks wierd. As would `David`s Book`.
> Perhaps I should invent a code like &^*$-m, which should
> never occur in text, to mean ' :-)
> The Que Sybase book I've got says "TEXT and IMAGE" types are the same, yet
> our server cries when I try to feed it 0x..... expecting a TEXT type. It
> also cries when I try to feed it 'The quick brown fox jumps over the lazy
> dog's tail.'
> Help!
> Many TIA,
> David.
> SOL Bors.