Problem with special character (accentuation)

Hello, I identified a special problem in updating the script (database => folder), via schema compare and compilation via sqlplus. 
The file is generated for schema compare in UT8- WITHOUT FIT.

Process Schema Compare:
 1- Source => Database
    Target => Script Folder
 2- via sqlplus
    SQL> @C:\colaborar\repositorio\PDPROD\Tables\BBACERVO_INTERNET.sql

Source database: 'Data da última atualização no registro';
Target database: 'Data da última atualização no registro';


  • Eddie DEddie D Posts: 1,617 Rose Gold 4
    Hi Robson,
    Thank you for your forum post and sorry that you have encountered a problem.

    I suspect that parser used by Schema Compare for Oracle is not handling the accented characters correctly.  As a supported customer, a support ticket has been created for you here.  You will need you RedgateID to be able to connect to the ticket.

    So I can attempt a reproduction, would it be possible to obtain the DDL for the table from the source and a copy of the .sql script from the target scripts folder?  Please update the support ticket with the requested information.

    Many Thanks
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.