CodeIgniter Forums

Full Version: Codeigniter connect with mssql, all chinese become question marks.
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

El Forum

Hi all,

I am new to codeigniter.

Inside my database.php, i have the following setting
$db['default']['char_set'] = 'utf8';
$db['default']['dbcollat'] = 'utf8_general_ci';
and chinese fields inside my sql server, collate is set as "Chinese_Taiwan_Stroke_CI_AI"
and also i have tried the following setting
$db['authsvr']['dbcollat'] = 'Chinese_Taiwan_Stroke_CI_AI';
$db['authsvr']['char_set'] = 'big5';

However, both of the above setting will lead all chinese characters become question marks.
I tried the function mb_detect_encoding() to see the result, it return ASCII for that "question mark" string.
name: ???->ASCII
My files and output are as UTF-8
Is there any idea to figure out the problem?

Thanks for all help.