Bug Report #3048

MSSQL SET NAMES error

Added by slik jay about 4 years ago. Updated about 4 years ago.

Status:ClosedStart date:07/05/2010
Priority:NormalDue date:
Assignee:Woody Gilk% Done:

0%

Category:Modules:Database
Target version:v3.0.7
Resolution:invalid Points:

Description

I found error using pdo (mssql).

PDOException [ HY000 ]: SQLSTATE[HY000]: General error: 195 General SQL Server error: Check messages from the SQL Server [195] (severity 15) []
MODPATH/database/classes/kohana/database/pdo.php [ 65 ]
$this->_connection->exec('SET NAMES '.$this->quote($charset));

message from mssql_query(): 'names' is not a recognized SET option.

Looks like mssql doesn't support SET NAMES in MSSQL2008/2005

History

#1 Updated by Woody Gilk about 4 years ago

  • Category set to Modules:Database
  • Status changed from New to Feedback
  • Assignee set to Woody Gilk
  • Target version set to v3.0.7

To disable SET NAMES, set the charset configuration setting to NULL or any empty value.

#2 Updated by Woody Gilk about 4 years ago

  • Status changed from Feedback to Closed
  • Resolution set to wontfix

#3 Updated by Woody Gilk about 4 years ago

  • Resolution changed from wontfix to invalid

Also available in: Atom PDF