Import UTF-8 encoded Oracle DB into MS SQL
From: ah_la_ma <ah_la_ma_at_yahoo.com>
Date: Tue, 17 Jun 2003 23:10:42 +0800
Message-ID: <3eef2fca$1_at_news.starhub.net.sg>
Date: Tue, 17 Jun 2003 23:10:42 +0800
Message-ID: <3eef2fca$1_at_news.starhub.net.sg>
Need some advice on importing UTF-8 encoded records from Oracle into MS SQL which is UCS-2 encoded. Does Microsft provided Oracle Driver or Oracle provioded ODBC Driver support auto conversion or we need to perform own conversion.
Anyone has any suggestion on ways to import double byte record (UTF-8 encoded) from Oracle to MS SQL? Auusming that SQL table is storing UCS-2 encoded records.
Many thanks for any suggestion. Received on Tue Jun 17 2003 - 17:10:42 CEST