Home » RDBMS Server » Server Administration » character problem of migration
character problem of migration [message #58010] Thu, 24 July 2003 19:21 Go to next message
David
Messages: 110
Registered: November 1998
Senior Member
i want to migrate the data from oracle to excel ,

why the characters turn to be "????????" in excel
Re: character problem of migration [message #58021 is a reply to message #58010] Fri, 25 July 2003 12:15 Go to previous message
Thomas G
Messages: 58
Registered: April 2003
Member
First check the Character set of the DB :

do an "select * from nls_database_parameters" when connected as system - user. And remember [[NLS_LANGUAGE]], [[NLS_TERRITORY]] and [[NLS_CHARACTERSET]]

On Windows (Where Excel is running, I assume) check with regedit, that HKEY_LOCAL_MACHINEsoftwareoracehome0nls_lang is matching.

It should be [[NLS_LANGUAGE]]_[[NLS_TERRITORY]].[[NLS_CHARACTERSET]] with the same values as the select before.
Previous Topic: check alerts on NT
Next Topic: Create Rollback Segment
Goto Forum:
  


Current Time: Fri Sep 20 09:33:32 CDT 2024