Home >Backend Development >PHP Tutorial >Solution to Chinese characters appearing in php mssql date_PHP tutorial
Solution to Chinese characters appearing in php mssql date_PHP tutorial
- WBOYOriginal
- 2016-07-21 15:47:26921browse
For example: after reading: 2005-12-23, the page will be displayed as: 2005 December 23, which brings a lot of inconvenience to the program. After searching some information, I found that php.ini has the date processing function by default.
The solution is:
The first method: define ini_set("mssql.datetimeconvert","0") at the beginning of the php document;
The second method: modify php.ini and find;mssql.datetimeconvert = On, remove the semicolon in front, change on to off, and restart apache
The third method: use SQL's convert() function to convert, such as:
SELECT id, title, convert( char(10),news_time,102) as publish_time, content FROM news