Bug: Text with embedded commas

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]

Posted by alan l batongbacal 24.205.189.97 on August 08 2007 03:41:31:

This is with SQL Server Express 2005. Let the test table be created and populated as follows:

CREATE TABLE x (y VARCHAR(50));
INSERT INTO x VALUES ('Hello,10;World,20');

If I tell SQL Script Builder 1.6.0.19 to create table and data statements for MS SQL, I get:

/* Created with SQL Script Builder v.1.6.0.19 */
/* 8/8/2007 12:35:59 AM */
/* Type of SQL : MS SQL */

CREATE TABLE [x] (
[y] [varchar] (50)
)

INSERT INTO [x] (y)
VALUES ('Hello.9;World.27')

Note that the embedded commas have been changed to full stops.

Follow Ups:

Re: Bug: Text with embedded commas - Dave 16:07:24 August 08 2007 (0)

Post a Followup

* : (Required)

* Name:
E-Mail:

* Subject:

* Comments:
> This is with SQL Server Express 2005. Let the test table be created and populated as follows: > > CREATE TABLE x (y VARCHAR(50)); > INSERT INTO x VALUES ('Hello,10;World,20'); > > If I tell SQL Script Builder 1.6.0.19 to create table and data statements for MS SQL, I get: > > /* Created with SQL Script Builder v.1.6.0.19 */ > /* 8/8/2007 12:35:59 AM */ > /* Type of SQL : MS SQL */ > > CREATE TABLE [x] ( > [y] [varchar] (50) > ) > > INSERT INTO [x] (y) > VALUES ('Hello.9;World.27') > > Note that the embedded commas have been changed to full stops. >

Optional Link URL:
Link Title:
Optional Image URL:

Enter the code shown :

[ Follow Ups ] [ Post Followup ] [ SQL Script Builder Forum ]