Title: [Plugin wp-db-abstraction] database error
Last modified: August 20, 2016

---

# [Plugin wp-db-abstraction] database error

 *  [dzs50](https://wordpress.org/support/users/dzs50/)
 * (@dzs50)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/plugin-wp-db-abstraction-database-error/)
 * I get the following error message during the install of wordpress on an mssql
   server
 * WordPress database error: [Unicode data in a Unicode-only collation or ntext 
   data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version
   3.7 or earlier.]
    SELECT option_value FROM wp_options WHERE option_name = ‘home’–
   PREPARE WordPress database error: [Unicode data in a Unicode-only collation or
   ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC 
   version 3.7 or earlier.] SELECT option_value FROM wp_options WHERE option_name
   = ‘siteurl’–PREPARE WordPress database error: [The statement has been terminated.]
   INSERT INTO `wp_options` (`option_name`, `option_value`, `autoload`) VALUES (‘
   home’, ‘[http://xxx.co.uk/wordpress&#8217](http://xxx.co.uk/wordpress&#8217);,‘
   yes’) ON DUPLICATE KEY UPDATE `option_name` = VALUES(`option_name`), `option_value`
   = VALUES(`option_value`), `autoload` = VALUES(`autoload`)–PREPARE

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [pepinho](https://wordpress.org/support/users/pepinho/)
 * (@pepinho)
 * [14 years, 1 month ago](https://wordpress.org/support/topic/plugin-wp-db-abstraction-database-error/#post-2550751)
 * I have the same problem…please, can somebady answer ?
 *  [pepinho](https://wordpress.org/support/users/pepinho/)
 * (@pepinho)
 * [14 years, 1 month ago](https://wordpress.org/support/topic/plugin-wp-db-abstraction-database-error/#post-2550752)
 * I have resolved this problems:
    For fix this issues you must edit the file “translations.
   php” in “sqlsrv” folder:
 * For the error “[Unicode data in a Unicode-only collation or ntext data cannot
   be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.]”
   the solution is edit the code
 * `$query = substr_replace($query, 'NVARCHAR(<strong>MAX</strong>)', $start_pos,
   strlen($ac_type));`
 * in
 * `$query = substr_replace($query, 'NVARCHAR(<strong>900</strong>)', $start_pos,
   strlen($ac_type));`
 * For the error “[The statement has been terminated.]” add line code
 * `return $update;`
 * after
 * `$this->following_query = $update;` and before of the ‘}’
 * in the ‘on_duplicate_key’ function.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘[Plugin wp-db-abstraction] database error’ is closed to new replies.

 * 2 replies
 * 2 participants
 * Last reply from: [pepinho](https://wordpress.org/support/users/pepinho/)
 * Last activity: [14 years, 1 month ago](https://wordpress.org/support/topic/plugin-wp-db-abstraction-database-error/#post-2550752)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics