DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Nls

  1. #1
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262

    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

  2. #2
    Join Date
    Jan 2001
    Posts
    642
    What is the OS?
    There is always a better way to do the things.

  3. #3
    Join Date
    Jan 2001
    Posts
    642
    If the OS is Unix -> check the doc.id 1006497.6 on metalink
    There is always a better way to do the things.

  4. #4
    Join Date
    Jan 2001
    Posts
    642
    There is always a better way to do the things.

  5. #5
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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

  6. #6
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    Thank you all of you!
    Hemant

  7. #7
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    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

  8. #8
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    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

  9. #9
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    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

  10. #10
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    "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
  •  


Click Here to Expand Forum to Full Width