oracle://user:password@service?
ClientCharset=charset& LowerCaseColumnNames=0& NLS_LANG=RUSSIAN_AMERICA.CL8MSWIN1251&
NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SS&
NLS_LANGUAGE=language-dependent conventions&
NLS_TERRITORY=territory-dependent conventions&
NLS_DATE_LANGUAGE=language for day and month names&
NLS_NUMERIC_CHARACTERS=decimal character and group separator&
NLS_CURRENCY=local currency symbol&
NLS_ISO_CURRENCY=ISO currency symbol&
NLS_SORT=sort sequence&
ORA_ENCRYPT_LOGIN=TRUE
ClientCharset-specifies the charset, in which Parser must communicate with SQL server. Conversion will be done by driver.
If you do not quote columns' names in select query, oracle will convert them to UPPERCASE. By default, Parser converts them to lowercase. By specifying LowerCaseColumnNames=0 one can disable this lowercase conversion.
While execution queries with limit/offset the driver modifies statements for cutting off not redundant data using SQL server instructions. But if any problems occurs this behaviour can be switched off with option DisableQueryModification=1.
Information on other parameters can be found in Oracle documentation.
Example
Assume, data in your database is stored in windows-1257, connect string should look like this:
oracle://user:password@service?ClientCharset=windows-1257&NLS_LANG=RUSSIAN_AMERICA.CL8MSWIN1251&NLS_DATE_FORMAT=YYYY-MM-DD HH24:MI:SS