By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,498 Members | 1,564 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,498 IT Pros & Developers. It's quick & easy.

No Notifications appears when converting text column to varchar column

Krishna Ladwa
P: 3
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
Share this question for a faster answer!
Share on Google+

Post your reply

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