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. 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