Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: Reference Index > Database Conversion

ODBC Compliance

Scroll Prev Top Next More

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=%

 

Continue below to ensure your database files are Y2K compliant.