Good Morning Steve
The insertion of comma in your Data works if your columns are VARCHAR and
you have place Data Value in 'tick marks'
e.g.
mysql> alter table test CHANGE test test VARCHAR(100);
Query OK, 1 row affected (0.03 sec)
Records: 1 Duplicates: 0 Warnings: 0
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
mysql> desc test.test
-> ;
+-------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------+--------------+------+-----+---------+-------+
| test | varchar(100) | YES | | NULL | |
+-------+--------------+------+-----+---------+-------+
1 row in set (0.00 sec)
mysql> insert into test.test value('Oracle Corporation 10 Van der Graaf,
Burling
ton MA');
Query OK, 1 row affected (0.00 sec)
mysql> select * from test.test;
+----------------------------------------------------+
| test |
+----------------------------------------------------+
| Oracle Corporation 10 Van der Graaf, Burlington MA |
+----------------------------------------------------+
1 rows in set (0.00 sec)
Viel Gluck/Buena Suerte
Martin--
----- Original Message -----
From: "Steve Edberg" <[EMAIL PROTECTED]>
To: "J. Todd Slack" <[EMAIL PROTECTED]>;
<mysql@lists.mysql.com>
Sent: Sunday, March 09, 2008 1:00 AM
Subject: Re: Comma's in data?
> At 11:52 PM -0800 3/7/08, J. Todd Slack wrote:
> >Hi All,
> >
> >I have a client that wants to insert data into a VarChar field that
contains
> >commas. These are property addresses.
> >
> >Example:
> >2966 Moorpark Ave, San Jose, CA, 95128
> >
> >1 Infinite Loop, Cupertino, CA, 955555
> >
> >How can I allow this?
> >
> >Thanks!
> >-Jason
>
>
> I've never had to escape commas; only special characters, eg: '_%.
> MySQL seems to ignore escaping if the following character is not
> special, though:
>
>
>
> [EMAIL PROTECTED]> create table test (t1 varchar(255));
> Query OK, 0 rows affected (0.03 sec)
>
> [EMAIL PROTECTED]> insert into test values ('qwert'),
> ('qwe,rt'),('qwe\,rt');
> Query OK, 3 rows affected (0.00 sec)
> Records: 3 Duplicates: 0 Warnings: 0
>
> [EMAIL PROTECTED]> select * from test;
> +--------+
> | t1 |
> +--------+
> | qwert |
> | qwe,rt |
> | qwe,rt |
> +--------+
> 3 rows in set (0.00 sec)
>
>
>
> Are you getting an error when you insert a row? If so, what is the
> error? Perhaps you are having a character set issue. This is what
> mine looks like:
>
>
>
> [EMAIL PROTECTED]> show variables like 'character\_set\_%';
> +--------------------------+--------+
> | Variable_name | Value |
> +--------------------------+--------+
> | character_set_client | latin1 |
> | character_set_connection | latin1 |
> | character_set_database | latin1 |
> | character_set_results | latin1 |
> | character_set_server | latin1 |
> | character_set_system | utf8 |
> +--------------------------+--------+
> 6 rows in set (0.00 sec)
>
>
> steve
>
>
> --
> +--------------- my people are the people of the dessert, ---------------+
> | Steve Edberg http://pgfsun.ucdavis.edu/ |
> | UC Davis Genome Center [EMAIL PROTECTED] |
> | Bioinformatics programming/database/sysadmin (530)754-9127 |
> +---------------- said t e lawrence, picking up his fork ----------------+
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
