ASCII characters below 32

[DuWayne_Engman_(Guest)]

Is the ANY way R&R version 6.5.08 can read and output ASCII characters below 32 (i.e. CR(ASCII 13) and LF (ASCII 10) when contained inside of database fields.____No matter how I set up the field I am trying to access (word wrap, whatever), or what parameters I include in the INI files, R&R just ignores these characters. I know they are there, I can see them in the field within the application that created the data, but it uses R&R for ^ad hoc^ reporting and I cannot see them there.____I do not care in what form I get the data out - ^printed^ to a file, text data file, export as dbf or excel - anything.____Maybe the runtime can do something through its parameter text files (control file)?____Please help - I am desparate

[kfleming]

The setting goes in RSWSQL.INI for the SQL version.____The line to add is:__DBANSI=0____and it needs to go into the named section that corresponds to the ODBC data source that you are using.____You can search for DBANSI in the RSWSQL.INI file for a description of its usage.________Kathleen__R&R Support

[Colin_Dow_(Guest)]

Hi. Not sure if u were looking to actually display a representation of characters or just make the fields appear as they do in access/sql server.__We use 6.5.08 and include the following settings in the RSW.file to force cr/lf to display.Create the section if its not there.____I^m not sure what the interaction is between these settings Kathleens.__If you are in any doubt I would use hers!____[Special]__CharRaw=1__AsciiEditor=1

[Colin_Dow_(Guest)]

oops the section is called ____[Special]

[Colin_Dow_(Guest)]

Now I really look like a moron.____The section is called Special - dont forget the square brackets!

[kfleming]

You are absolutely correct that these RSW.INI settings are the solution. And I am absolutely brain dead for having not suggested the correct solution in the first place.__Thanks for the answer.______Kathleen__R&R Support

[DuWayne_Engman_(Guest)]

Thanks both of you so much for all the suggestions. I^ll give them a try and let you know.______>Hi. Not sure if u were looking to actually display a __>representation of characters or just make the fields appear __>as they do in access/sql server. __>We use 6.5.08 and include the following settings in the __>RSW.file to force cr/lf to display.Create the section if its __>not there. __>__>I^m not sure what the interaction is between these settings __>Kathleens. __>If you are in any doubt I would use hers! __>__>[Special] __>CharRaw=1 __>AsciiEditor=1 __