Currently, we have SQL Server 2005 database linked to Oracle database (ANSI). We are planning on converting Oracle database to Unicode. Our customer has some scripts running on SQL server database that updates some SQL Server ANSI fields getting data from Oracle database(using linked server). Would like to know if there could be any known issues updating SQL Server ANSI fields from an Oracle Unicode database (using linked server)? Also, how can I find out if a SQL Server column is ANSI?
Thank you so much for your help..
Cannot remember any issues although I've always "Staged and Explicit Convert" instead of relying on implicit conversions.
To view the data types use something like
,T.name AS TABLE_NAME
,C.name AS COLUMN_NAME
,TY.name AS DATA_TYPE
,C.collation_name AS CHAR_COLLATION
FROM sys.tables T
INNER JOIN sys.columns C
ON T.object_id = C.object_id
INNER JOIN sys.types TY
ON C.system_type_id = TY.system_type_id;