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

Thread: character set not compatible

  1. #1
    Join Date
    Jan 2000
    Posts
    387

    character set not compatible

    I have created a new database version 9.2 with characterset AL32UTF8 and national characterset AL16UTF8.

    The old database which I try to import from is using characterset US7ASCII instead.

    This will caused an error shown below when I try to connect to a function or procedure using a db link.

    ERROR:
    ORA-06550: line 1, column 29:
    PLS-00553: character set name is not recognized
    ORA-06550: line 0, column 0:
    PL/SQL: Compilation unit analysis terminated

    How do i solve this??

  2. #2
    Join Date
    Jan 2000
    Posts
    387
    By the way, I have alter the database character set and national character set to UTF8 before the export form the old database 8.1.7 before the import into the new database 9.2.0. But it still doesn't work and even caused some records to be lost as the columns are too large...

    Extracted from my export log:
    Export file created by EXPORT:V08.01.07 via conventional path
    import done in UTF8 character set and AL16UTF16 NCHAR character set
    import server uses AL32UTF8 character set (possible charset conversion)
    export server uses UTF8 NCHAR character set (possible ncharset conversion)

    Any help please? Many thanks in adavance!
    Last edited by mooks; 06-11-2004 at 05:47 AM.

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