Oracle Character set question [message #349347] |
Sat, 20 September 2008 09:27 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|