If you are planning on using ODBC with R:BASE, you must make sure that your character settings are set correctly by performing the following:
| 1. | Go to the R> Prompt |
| 2. | Connect to your database |
| 3. | Type: SHOW CHAR |
| 4. | Compare your values to the chart below |
Character |
Set To |
Description |
MANY |
% |
Percent Sign |
SINGLE |
_ |
Underscore |
QUOTES |
' |
Single Quote |
| 5. | If they do not match, change them by typing SET TYPE=CHAR |
(where TYPE is from the "Character" column and CHAR from the "Set To" column)
For example, SET MANY=%
ODBC Topics:
Connecting Data Sources and Tables
Disconnecting Data Sources and Tables
See also:
