Page 1 of 1
ASCII characters below 32
Posted: Tue Dec 11, 2001 1:29 pm
by 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
=> RE: ASCII characters below 32
Posted: Tue Dec 11, 2001 9:27 pm
by 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
==> RE: ASCII characters below 32
Posted: Wed Dec 12, 2001 5:21 am
by 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
===> RE: ASCII characters below 32
Posted: Wed Dec 12, 2001 5:23 am
by Colin_Dow_(Guest)
oops the section is called ____[Special]
====> RE: ASCII characters below 32
Posted: Wed Dec 12, 2001 5:24 am
by Colin_Dow_(Guest)
Now I really look like a moron.____The section is called Special - dont forget the square brackets!
=====> RE: ASCII characters below 32
Posted: Wed Dec 12, 2001 7:28 am
by 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
===> RE: ASCII characters below 32
Posted: Wed Dec 12, 2001 9:11 am
by 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 __