On Sun, Mar 22, 2009 at 08:48:14AM -0400, dariuszs wrote:
Hi, This should return exactly what you input "MERS'' not "MERS' It looks like single quote is used as an escape character? Is that correct? Is there a way to turn off escape characters like "\" and "'" and read in data as it is? Thanks. Dariusz.
Sql indeed uses ' as an escape character, thats which inserting "MERS'' requires you to insert with the value '"MERS''''' Niels
Niels Nes wrote:
On Sat, Mar 21, 2009 at 06:14:14PM -0400, dariuszs wrote:
Hi, How do I insert this value into a varchar(20) column? I get an error. "MERS''
sql>select '"MERS'''; +--------------+ | single_value | +==============+ | "MERS' | +--------------+ 1 tuple sql>create table x (x varchar(20)); 0 tuples sql>insert into x values ('"MERS'''); Rows affected 1
Niels
Thanks. Dariusz.
------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are powering Web 2.0 with engaging, cross-platform capabilities. Quickly and easily build your RIAs with Flex Builder, the Eclipse(TM)based development software that enables intelligent coding and step-through debugging. Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl