Hi, m getting an Error when m converting a charater type to a numeric type ie to int or float through ALTER COLUMN command ERROR IS: Cannot convert a char value to money. The char value has incorrect syntax. The statement has been terminated.
We currently have an instance in use that has the characterset of US7ASCII. The vendor of the application running on that instance has suggested we change to WE8MSWIN1252. do you think that any data could get corrupted when going from a 7-bit characterset to the 8-bit one and can we do this in...