Home » RDBMS Server » Server Administration » Oracle Character set question (Oracle, 10g, Unix)
Oracle Character set question [message #349347] Sat, 20 September 2008 09:27 Go to next message
skumar08
Messages: 4
Registered: September 2008
Junior Member
All,
Have a question on character sets. We have a db2 database which is in ISO 8859_1 character set and one of the table stores user passwords. Now, we are migrating from DB2 to Oracle 10g using SQL Loader and the character set in Oracle 10g is set to UTF-8. The question to all the Oracle experts is when this data transfer is done, would the password field come over in the same format? Would the data load be an issue because of different character sets? If so, how could we resolve this?

Thanks in advance for your replies.
Santhosh
Re: Oracle Character set question [message #349362 is a reply to message #349347] Sat, 20 September 2008 13:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
would the password field come over in the same format?

If this is a character datatype it is converted to database character set.
If this is a binary (raw) datatype, no conversion takes place.

Quote:
Would the data load be an issue because of different character sets?

If you use correct NLS_LANG parameters, this will cause no problem.

Regards
Michel
Re: Oracle Character set question [message #349375 is a reply to message #349362] Sat, 20 September 2008 15:59 Go to previous messageGo to next message
skumar08
Messages: 4
Registered: September 2008
Junior Member
Thanks for your quick response Michel. Unfortunately, the password field is a Varchar(20) in DB2 V8.1 and is converted to the database character set. So if we were to use the correct NLS_LANG, would the data load into Oracle 10g still be an issue because of the character conversion?

Thanks
Santhosh.
Re: Oracle Character set question [message #349381 is a reply to message #349375] Sun, 21 September 2008 00:46 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends if you store clear passwords, encrypted passwords with common character, encrypted passwords with all possible code points, encrypted passwords with all byte values, and how you use them.

Regards
Michel

Previous Topic: create directory object on a client machine
Next Topic: Error on Alert Log
Goto Forum:
  


Current Time: Sun Dec 04 20:32:35 CST 2016

Total time taken to generate the page: 0.06602 seconds