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
Note
There is also a special construction used for long string literals. Oracle cannot handle long strings properly. If a string input, which is transferred, for example, from form to database, is more than 2000 [Oracle 7.x] or 4000 [Oracle 8.x] characters long, the server will report an error like "literal is too long." If you try to cheat by combining "2000 characters" + "2000 characters" there will be another error like "sum is too great." To store such constructions, we usually use data type CLOB [Oracle] and OID [PgSQL] and, to make SQL commands simplest, we should add a control comment which will be properly interpreted by a driver of SQL server:
insert into news text values (/**text**/'$form:text')
Word text in construction /**text**/ is the name of a column to which we input the string that follows. There must be NO spaces inside it!