Varchar data

Article View: bit.databases.mssql-l

Article #241

Back to bit.databases.mssql-l Previous Next

#241

From: Susana Olivares Melton
Date: Thu, 21 Oct 1999 00:00

9 lines
700 bytes

Trying to insert data into an SQL db that contains single quotes, so SQL
thinks the code ends at the '.

For example, the input is my mom's house. SQL truncates at ' and I get a
damned error.

Quick fix?

Thanks.

Technical Details

Message-ID: <7ummmc$5rp$1@unlisys.unlisys.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6611,c2d02c60e35dd25,start
X-Google-Attributes: gidf6611,public
From: "Susana Olivares Melton" <susana.olivares@iucn.org>
Subject: Varchar data
Date: 1999/10/21
Message-ID: <7ummmc$5rp$1@unlisys.unlisys.net>
X-Deja-AN: 538774459
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
Organization: [Posted via] Interactive Networx
X-MSMail-Priority: Normal
Newsgroups: bit.databases.mssql-l