Keep Server Online
If you find the Apache Lounge, the downloads and overall help useful, please express your satisfaction with a donation.
or
A donation makes a contribution towards the costs, the time and effort that's going in this site and building.
Thank You! Steffen
Your donations will help to keep this site alive and well, and continuing building binaries. Apache Lounge is not sponsored.
| |
|
 Topic: Show Chinese Date |
|
| Author |
|
SabinF
Joined: 03 May 2006
Posts: 37
Location: Timisoara (Romania)
|
 Posted: Wed 23 May '07 0:17 Post subject: Show Chinese Date |
 |
|
Hello, I'm trying to show date in Chinese the following way:
Query: SET lc_time_names = 'zh_CN';
Query: SELECT DAYNAME('2007-01-01');
The problem is that when I output the result with PHP i get: '????'.
I tried using the htmlentities function, but with no luck. I also tried changing the charset from utf-8 to gb2312 and still nothing. Can anyone help me? |
|
| Back to top |
|
James Blond
Moderator
Joined: 19 Jan 2006
Posts: 7371
Location: Germany, Next to Hamburg
|
| Posted: Wed 23 May '07 9:51 Post subject: |
|
|
There is a way to convert the characters using multibyte String functions (mb_*)
I know that this exists, but I have never worked with that.
It would be nice if you tell us how mb_* works if you are done! |
|
| Back to top |
|
SabinF
Joined: 03 May 2006
Posts: 37
Location: Timisoara (Romania)
|
| Posted: Thu 24 May '07 19:59 Post subject: |
|
|
I don't understand how to use mbstring. Anyway, it seems that I get this output even when i use setlocale with LC_TIME to chinese and use strftime. If any one of you has any info, it would be appreciated. Thanks.
| Code: | <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Test</title>
</head>
<body>
<?php
setlocale(LC_TIME, "Chinese");
echo strftime("%B");
?>
</body>
</html> |
|
|
| Back to top |
|
|
|
|
|
|
