August 8, 2006 at 1:57 am
Hello guys,
I have a SQL server 2000 SP4 on Windows 2000 SP4 (CP 1250, Czech_CI_AS) and Oracle 9.2.0.6.0 DB on Windows with the NLS_NCHAR_CHARACTERSET = AL16UTF16, NLS_CHARACTERSET = EE8MSWIN1250 and NLS_LANGUAGE = CZECH, so Oracle accepts and represents all the czech characters correctly. MS SQL and Oracle are connected via a Linked Server using MS OLE DB Provider for Oracle nad when I migrate siome tables to Oracle I always loose my czech spec. characters. When I check migrated data via sqlplus I see only "?" instead of my czech char. I tried to set up many kinds of collations in the Linked Server properties but nothing helped. Can anybody help? I tried to use DTS also, but the same result neither via OLE DB Provider nor via ODBC.
Thank you in advance
Radek Brazda
August 9, 2006 at 10:24 am
You are getting Character conversion in Oracle because you have not done Unicode collation in Oracle. I have not done it in Oracle so check Oracle docs and the try the link below to get started. Hope this helps.
http://www.indiawebdevelopers.com/technology/oracle9i/unicode.asp
Kind regards,
Gift Peddie
Kind regards,
Gift Peddie
August 10, 2006 at 3:45 am
TRhank you I will check it, I also tried to replicate the problem on my loval laptot wotjh teh same Oracle and MS SQL, but I installed full oracle client and it helped. On the customer's machine I connected MS SQL and Oracle using Instant Oracle Client. So may be this was the problem. I will see.
Thanks for the advise.
Rade
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply