OracleScript not detect ANSI text

[Consinco]

OracleScript not detect ANSI text, to run the update the accents of the texts are exchanged, how can I solve?

AListScript.LoadFromFile('c:\atu.pdc');
AListScript.DefaultEncoding := TEncoding.ANSI;

OraScript := TOracleSession.Create(nil);
OraScript.Session := OracleSession;
OraScript.ScanVariables := False;
OraScript.OutputOptions := [ooError];
OraScript.Lines.Assign(AListScript); // -> AListScript ANSI
OraScript.Execute;

Result:
'Redu磯 n㯠exportada'

 

[Marco Kalter]

Can you let me know the NLS_LANG for your Oracle Session? It may be that the ANSI characters do not match the character set of the NLS_LANG.

 

[Consinco]

NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1

This only happens when I run by TOracleScript. example create a package, procedure or function that contains text with an accent.

 

[Marco Kalter]

Can you also let me know the character set of the database?

 

[Consinco]

NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16

 

[Consinco]

Any suggestions?

 

[Marco Kalter]

These are session parameters. Can you let me know the character set that the database was created with?

select value from nls_database_parameters
where parameter = 'NLS_CHARACTERSET'

 

[Consinco]

Had already posted

NLS_CHARACTERSET WE8MSWIN1252

Only occurs when I use OracleScript when using OracleQuery works normally!

 

[Consinco]

Can you help me with this? Tks.

 

[Consinco]

Any tips please?

 

[Marco Kalter]

We can;t reproduce this. Can you send me a little demo project?

 

[Consinco]

Compile in XE3 solve the problem, have not had time to investigate the issue in XE5.

Thanks again!