Re: Bug: Text with embedded commas

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

Posted by Dave on August 08 2007 16:07:24:

In Reply to: Bug: Text with embedded commas posted by alan l batongbacal on August 08 2007 03:41:31:

Hi Alan,

We beleive we solved the issue today in releasing version 1.6.0.20.

Commas were removed for the numeric values working correctly, now commas are preserved in text fields.

Dave

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

Post a Followup

* : (Required)

* Name:
E-Mail:

* Subject:

* Comments:
> Hi Alan, > > We beleive we solved the issue today in releasing version 1.6.0.20. > > Commas were removed for the numeric values working correctly, now commas are preserved in text fields. > > Dave > > > 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 ]