469,645 Members | 1,193 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,645 developers. It's quick & easy.

No Notifications appears when converting text column to varchar column

Krishna Ladwa
In Sql Server 2000 Version, I found that no Notification message box appears when converting text column to varchar but the data gets truncated to the given size for the varchar. Whereas it appears when you convert the varchar column to text column.

Do this through Enterprise Manager Console

Create a New table with a column as varchar datatype from Enterprise Manager  table created  Open the table and add one row  Successfully added the row  Open the table in Design Mode  Change the datatype to text and click on save  Gives Notification: 'test' table- Warning: Data may be lost converting column 'test' from 'varchar(255)'.  Successfully changed the column form varchar to text


Create a New table with a column as text datatype from Enterprise Manager  table created  Open the table and add one row with data length greater than 255 (long text)  Successfully added the row  Open the table in Design Mode  Change the datateype to varchar(255) and click on Save  Successfully changed the column from text to varchar  Open the table and verify the row data. Data got truncated to length 255 without any notifications


WHY??????????
Aug 29 '07 #1
0 1491

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

5 posts views Thread by Barbara Lindsey | last post: by
1 post views Thread by simon | last post: by
reply views Thread by simon | last post: by
3 posts views Thread by Steve Atkins | last post: by
12 posts views Thread by Frederik Vanderhaeghe | last post: by
5 posts views Thread by Patti | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.