SOLVED: MSSQL odbc problem - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5) +--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24) +--- Thread: SOLVED: MSSQL odbc problem (/showthread.php?tid=318) |
SOLVED: MSSQL odbc problem - blunde - 11-20-2014 Hi Trying to use CodeIgniter with odbc to a old MSSQL server. When fetching the results some of the fields are truncated. Ex. ["Frame9Val"]=> string(3) "13" --- should show 135 Ex. ["Frame1BVal"]=> string(3) "2�" --- should show 255 Any idea why this is happening? It's working when using plain PDO outside CI \B RE: MSSQL odbc problem - Rufnex - 11-20-2014 Looks like a charset problem? have you checked the database config (char_set, dbcollat)? RE: MSSQL odbc problem - blunde - 11-20-2014 (11-20-2014, 01:54 PM)Rufnex Wrote: Looks like a charset problem? have you checked the database config (char_set, dbcollat)? Yes, tried different settings without any luck. RE: MSSQL odbc problem - Rufnex - 11-20-2014 Are you on windows or a unix server? P.S. Your PM are off ^^. RE: MSSQL odbc problem - blunde - 11-20-2014 (11-20-2014, 03:27 PM)Rufnex Wrote: Are you on windows or a unix server? CentOS linux using FreeTDS and unixODBC RE: MSSQL odbc problem - Rufnex - 11-21-2014 I use CI3 with the following settings and with FreeTDS without any problems: PHP Code: $db['default'] = array( RE: MSSQL odbc problem - blunde - 12-02-2014 Thank you so much! This was the fix I needed (11-21-2014, 04:57 AM)Rufnex Wrote: I use CI3 with the following settings and with FreeTDS without any problems: |