| Oracle Character set question [message #349347] |
Sat, 20 September 2008 09:27  |
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 #349375 is a reply to message #349362] |
Sat, 20 September 2008 15:59  |
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 |
 |
Michel Cadot
Messages: 68666
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
