• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Codeigniter connect with mssql, all chinese become question marks.

#1
[eluser]CyrusTC[/eluser]
Hi all,

I am new to codeigniter.

Inside my database.php, i have the following setting
Code:
$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
Code:
$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.
Code:
name: ???->ASCII
My files and output are as UTF-8
Is there any idea to figure out the problem?


Thanks for all help.


Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.