Posted By: Consinco OracleScript not detect ANSI text - 11/09/13 01:13 PM
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ção não exportada'
Posted By: Marco Kalter Re: OracleScript not detect ANSI text - 11/11/13 10:48 AM
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.
Posted By: Consinco Re: OracleScript not detect ANSI text - 11/11/13 07:46 PM
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.
Posted By: Marco Kalter Re: OracleScript not detect ANSI text - 11/12/13 10:58 AM
Can you also let me know the character set of the database?
Posted By: Consinco Re: OracleScript not detect ANSI text - 11/12/13 11:52 AM
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
Posted By: Consinco Re: OracleScript not detect ANSI text - 11/13/13 12:13 PM
Any suggestions?
Posted By: Marco Kalter Re: OracleScript not detect ANSI text - 11/14/13 10:31 AM
These are session parameters. Can you let me know the character set that the database was created with?

Code
select value from nls_database_parameters
where parameter = 'NLS_CHARACTERSET'
Posted By: Consinco Re: OracleScript not detect ANSI text - 11/14/13 10:36 AM
Had already posted

NLS_CHARACTERSET WE8MSWIN1252

Only occurs when I use OracleScript when using OracleQuery works normally!
Posted By: Consinco Re: OracleScript not detect ANSI text - 11/20/13 01:54 PM
Can you help me with this? Tks.
Posted By: Consinco Re: OracleScript not detect ANSI text - 11/22/13 10:50 AM
Any tips please?
Posted By: Marco Kalter Re: OracleScript not detect ANSI text - 11/25/13 09:46 AM
We can;t reproduce this. Can you send me a little demo project?
Posted By: Consinco Re: OracleScript not detect ANSI text - 11/30/13 05:18 PM
Compile in XE3 solve the problem, have not had time to investigate the issue in XE5.

Thanks again!
© Allround Automations forums