Thread: Nls
-
Changing the NLS
Hi Gurus,
I have a database based on US (NLS).
I now have a need to import data from Europe and need to change my NLS settings.
Do I have to create an entirely new database with the settings and dump my old data in there?
Thanks!
Last edited by hemanr; 04-30-2003 at 01:15 PM.
Hemant
-
There is always a better way to do the things.
-
If the OS is Unix -> check the doc.id 1006497.6 on metalink
There is always a better way to do the things.
-
There is always a better way to do the things.
-
If the old character set is a sub-set of the new one, you can do an ALTER DATABASE CHARACTER SET . . . . It's in the National Language Support Guide, chapter 3.
(e.g. US7ASCII to WE8ISO8859P1 is OK).
Last edited by DaPi; 04-30-2003 at 01:31 PM.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
-
Hi DaPi,
I think we can use the alter database character set only if the new character set is a sub set of the old one...
Hemant
-
One of us has got this backwards 
You want the old to be a sub-set of the new - i.e. all the "old" characters included in new character set.
If the new is only a sub-set of the old then the "missing" characters - the ones that exist in the old but not the new - will be lost in some fashion (the manual will say exactly what happens to them).
Beware! we have been talking about sub-sets and the doc talks about super-sets!
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
-
Yp DaPi,
Need to sort out this. Actually Im exploring.
Ive been trying to get my hands on the NLS document you refer so much to. to no avail...any help here mate?
Hemant
-
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|