if data is to be stored within a column in a different collation than the database, they should be defined as Unicode column. this will double the storage space, but it ensures that data can be moved smoothly between columns.
typically, a computed column can be created on this kind of column with different collation to facilitate data access in different collation without explicit collation conversion.
No comments:
Post a Comment