[MonetDB-users] sql characters
Hi, How do I insert this value into a varchar(20) column? I get an error. "MERS''
Thanks. Dariusz.
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
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
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
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
Hi, How do I pass this using PHP (I've got list of commands in create_table.sql) < create_table.sql
Thanks. Dariusz.
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
participants (3)
-
dariuszs
-
Martin Kersten
-
Niels Nes