On Sun, Mar 22, 2009 at 08:53:17AM +0100, 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 And for "MERS'' sql>insert into x values ('"MERS''''');

Niels

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

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

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

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

dariuszs wrote:

Hi, How do I pass this using PHP (I've got list of commands in create_table.sql) \< create_table.sql

\< is a mclient command directive, not a SQL directive. You have to read the file and sent the commands

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