Hello,
Here is my problem:
I have two servers, one SQL Server 2000 with 1251 code page and the second SQL Server 6.5 with code page 850.The second server is a remote server on first and the first is remote on second server.
On first server I try to execute this query :
-----------
INSERT INTO server1.dbo.table1
SELECT ID, Submission,
FROM server2.db2.dbo.table2
WHERE ID = 1
---
Where server1 is SQLServer 2000 (code page 1251) and server2 is SQL 6.5 (code page 850). After executing of this query I can see only some strange characters stored in table1.
Thank you in advance,
Here is my problem:
I have two servers, one SQL Server 2000 with 1251 code page and the second SQL Server 6.5 with code page 850.The second server is a remote server on first and the first is remote on second server.
On first server I try to execute this query :
-----------
INSERT INTO server1.dbo.table1
SELECT ID, Submission,
FROM server2.db2.dbo.table2
WHERE ID = 1
---
Where server1 is SQLServer 2000 (code page 1251) and server2 is SQL 6.5 (code page 850). After executing of this query I can see only some strange characters stored in table1.
Thank you in advance,
