Ruby on Rails latest stable (v7.1.3.2)
-
0 notes
- Superclass:
ActiveRecord::ConnectionAdapters::AbstractAdapter
- 1.0.0
- 1.1.6 (0)
- 1.2.6 (0)
- 2.0.3
- 2.1.0
- 2.2.1
- 2.3.8
- 3.0.0
- 3.0.9
- 3.1.0
- 3.2.1
- 3.2.8
- 3.2.13
- 4.0.2
- 4.1.8
- 4.2.1
- 4.2.7
- 4.2.9
- 5.0.0.1
- 5.1.7
- 5.2.3
- 6.0.0
- 6.1.3.1
- 6.1.7.7
- 7.0.0
- 7.1.3.2
- 7.1.3.4
- What's this?
ActiveRecord connection adapter for Sybase Open Client bindings (see http://raa.ruby-lang.org/project/sybase-ctlib).
Options:
- :host — The name of the database server. No default, must be provided.
- :database — The name of the database. No default, must be provided.
- :username — Defaults to "sa".
- :password — Defaults to empty string.
Usage Notes:
- The sybase-ctlib bindings do not support the DATE SQL column type; use DATETIME instead.
- Table and column names are limited to 30 chars in Sybase 12.5
- :binary columns not yet supported
- :boolean columns use the BIT SQL type, which does not allow nulls or indexes. If a DEFAULT is not specified for ALTER TABLE commands, the column will be declared with DEFAULT 0 (false).
Migrations:
The Sybase adapter supports migrations, but for ALTER TABLE commands to work, the database must have the database option ‘select into’ set to ‘true’ with sp_dboption (see below). The sp_helpdb command lists the current options for all databases.
1> use mydb 2> go 1> master..sp_dboption mydb, "select into", true 2> go 1> checkpoint 2> go