DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: convert data after change character set

  1. #1
    Join Date
    Mar 2001
    Posts
    1
    Hi,

    I have changed the character set from US7ASCII to WE8ISO8859P1 for an 8i database by using:

    ALTER DATABASE CHARACTER SET WE8ISO8859P1;

    How can I convert the character code for the existing data?

  2. #2
    Join Date
    Nov 2000
    Posts
    205
    I have recently done this (except we have changed the characterset to we8mswin1252, so that the euro dollar is catered for), and from what I understand the data that is already saved cannot be changed.

    They would need to be loaded in again correctly.


    There are ways to search for these characters though. If you need some code to do this let me know.

    Good Luck,
    Nirasha

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