On Wed, 23 Jun 2004 12:42:23 +0100 (BST), cf coder wrote:
>
> I'm afraid this is a sql server question. I want to
> update a column in a table in design mode.
> I'm trying to change the data type (char) length from
> 30 to 50 characters. There is data that
> already exsits in the table (over 10000 rows). When I
> click on save I get a message which says:
>
> 'User' table
> - Warning: One or more existing columns have
> ANSI_PADDING 'off' and will be re-created with
> ANSI_PADDING 'on'.
> - Warning: The table was created with ANSI_NULLS 'off'
> and will be re-created with ANSI_NULLS 'on'.
>
> Not sure if by saving the changes I will loose any
> data. Can anybody help
It's telling you that it's changing the setting of the table, not that
it's going to truncate
Nothing really to worry about
BTW, why CHAR and not VARCHAR? Do you do the trimming once you get the
data into CF?
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- Changing the data type length - sql server cf coder
- Re: Changing the data type length - sql server Philip Arnold