Codeigniter error with SQL Server

Question

I am using sql server database drivers in codeigniter and I am executing the following query:

 select A.inst_name,Substring((Select ',' + cast(B.program_id as varchar(15))   
                               From    k12_dms_inst_programs B
                               Where B.inst_id=A.id For XML Path('')),2,8000) As EmployeeList
 From k12_dms_institution_master A
 Group by A.inst_name,A.id

which is working absolutely fine in SSMS.

But when I am trying to execute the same query using Codeigniter I am getting the following 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.

Sergey Telshevsky · Accepted Answer · 2012-12-12 09:11:01Z

1

Found some solutions on php.net

MSSQLNewbie 19-Sep-2011 06:34

In /etc/freetds/freetds.conf add these two lines (last two):
[global]
;tds version = 4.2
tds version = 8.0  
client charset = UTF-8

You can edit "charset" in php.ini too (but you don't need if you did it previously in freetds.conf):  
; Specify client character set.. 
; If empty or not set the client charset from freetds.comf is used 
; This is only used when compiled with FreeTDS mssql.charset = "UTF-8"

Use nchar/nvarchar/ntext column types if you need unicode support.

dann dot farquhar at iteams dot org 24-Sep-2009 11:45

I found that changing the version in /etc/freetds.conf from 4.2 to 8.0
fixes this problem without having to make any changes to the SELECT
statement

huberkev11 at hotmail dot com 12-May-2006 01:47

This is because you are using column types of like ntext instead of
text.  There are 2 solutions.

1  Change all ntext column types to text or
2  Your query must look like: SELECT CAST(field1 AS TEXT) AS field1 FROM table

Hope they will help.

answered Dec 12, 2012 at 9:11

Sergey Telshevsky

12.3k7 gold badges59 silver badges80 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Sergey Telshevsky Over a year ago

@user1163513 tell us which of them did help you!

Collectives™ on Stack Overflow

Codeigniter error with SQL Server

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related