> I'm getting a code page translation error for a text field From 1255 to
> How do I change the database so this does not happen. I assume I have to
> do something with the collation for the table but not sure.
Could you describe your problem more in detail? When do you get this
error? What collation does the table column have? And what codepage
is 1255? (1252 is Western Latin-1, that I know.)
To change the collation of a column, this statement appears to work:
alter table NEW_H alter column H_Name nvarchar(50)
I support PASS - the definitive global community for SQL Server
professionals - http://www.sqlpass.org
The PASS Community Summit is in Seattle Nov 19-22, I'll be there. And you?