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

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

Answers

  • Eddie DEddie D Posts: 1,780 Rose Gold 5
    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
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.