[FIXED] How to pass the charset and the Firebird's role using R

Issue

I'm trying to execute a select in Firebird using the R language. I know that Firebird needs a charset and role parameter, but I don't know how to pass this in R language. Default message without inform the charset

   WARNING: No connection character set specified (property lc_ctype, encoding, charSet or localEncoding), defaulting to character set NONE

Solution

The error message indicates you are using Jaybird (the Firebird JDBC driver). Given you haven't shown any information on how you connect, I'll answer from a generic usage perspective.

There are multiple ways to pass properties to Jaybird on connect, but the simplest (assuming you are using a JDBC URL), is to include those properties in the URL.

So if your URL is

jdbc:firebirdsql://localhost/employee

Then you can add properties by adding a ? and adding (&-separated) key=value pairs:

jdbc:firebirdsql://localhost/employee?charSet=utf-8&roleName=yourRole

For specifying the character set you can use either the property charSet with a Java character set or encoding with a Firebird character set. See also the Jaybird FAQ on character sets.

For specifying a role, you can use roleName.

See also the Jaybird JDBC Driver Java Programmer’s Manual and the list of connection properties on the wiki.

Answered By - Mark Rotteveel

Answer Checked By - Cary Denson (PHPFixing Admin)