CodeIgniter MSSQL encoding issue (question marks)

Question

I'm using CodeIgniter with the MSSQL driver ($db['default']['dbdriver']).

I'm connecting to a remote database. In the hostname i have the IP of the server. The database collation is SQL_Latin1_General_CP1_CI_AS.

The problem is that when I fetch the data, the Hebrew shows as question marks. I tried various combinations of charsets, iconv and mb conversions, but none seems to work.

I would think it's something in the connection string, but using the MSSQL driver there's not connection string. When I tried it with the ODBC driver it worked properly (the setup for the ODBC worked from my local machine but not from the server, which has the MSSQL extension installed, hence I'm using the MSSQL driver).

Any help will be appreciated.

I've switched to PDO and now sometimes I get:

Fatal error: Cannot access property started with '\0' in /var/www/clients/client1/web2/web/cliqa/ci/system/database/drivers/pdo/pdo_result.php on line 176

I supposed it happens when the connection fails. Sometimes it shows properly (but with question marks) and sometimes I get this error.

galchen · Accepted Answer · 2013-01-01 00:37:40Z

1

SOLUTION:

It was solved by a friend, and it had to do something with the configuration of the server:

cat /etc/freetds.conf

create a new instance

[annoyingRemoteHostSrv]
    host = IP_ADDRESS
    port = 1433 
    tds version = 8.0
    client charset = UTF-8

hope it helps anyone ;)

answered Jan 1, 2013 at 0:37

galchen

5,3003 gold badges32 silver badges44 bronze badges

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

Comments

Serg · Accepted Answer · 2012-12-29 15:25:05Z

0

Use Unicode data types if possible - nvarchar. So server collation doesn't affect your data regardless of source codepage.

answered Dec 29, 2012 at 15:25

Serg

2,4373 gold badges33 silver badges42 bronze badges

3 Comments

galchen Over a year ago

doesn't seem to work. I want to avoid making changes to the database, but it also doesn't work for existing data of this type

Serg Over a year ago

Can you check that data is fetched normally using SSMS? Maybe data initially is not correctly stored in database. One should use Hebrew collation in database to correctly store hebrew data.

galchen Over a year ago

this is a website that I have not written. I'm convinced that the data isn't stored properly - it uses latin charset instead of utf8 or hebrew encoding. I'm rebuilding the entire site and since it's active, during the migration process i want to use the original database using remote connection, until it is moved completely. When i fetched the data from my windows machine (using sqlsrv) it was decoded properly. I'm looking for a workaround

Collectives™ on Stack Overflow

CodeIgniter MSSQL encoding issue (question marks)

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related