PHP Help ?


by ngkamsengpeter
Tags: None
ngkamsengpeter
ngkamsengpeter is offline
#1
Jan5-07, 07:15 PM
P: 194
I use php to select data from the mysql database with chinese character but when I echo it ,it show ??? . I am sure the encoding is correct but it still don't show the chinese character . I am using IE 6 . Please help .
Phys.Org News Partner Science news on Phys.org
Going nuts? Turkey looks to pistachios to heat new eco-city
Space-tested fluid flow concept advances infectious disease diagnoses
SpaceX launches supplies to space station (Update)
chroot
chroot is offline
#2
Jan5-07, 07:16 PM
Emeritus
Sci Advisor
PF Gold
chroot's Avatar
P: 10,424
Do you have the appropriate fonts installed?

- Warren
ngkamsengpeter
ngkamsengpeter is offline
#3
Jan6-07, 08:07 PM
P: 194
Quote Quote by chroot View Post
Do you have the appropriate fonts installed?

- Warren
yes because I can see other chinese character .

gabee
gabee is offline
#4
Jan6-07, 08:51 PM
gabee's Avatar
P: 179

PHP Help ?


Quote Quote by ngkamsengpeter View Post
I use php to select data from the mysql database with chinese character but when I echo it ,it show ??? . I am sure the encoding is correct but it still don't show the chinese character . I am using IE 6 . Please help .
Are the mysql table and your PHP program using an appropriate data type to store the encoded Chinese characters?
ngkamsengpeter
ngkamsengpeter is offline
#5
Jan8-07, 07:23 PM
P: 194
Quote Quote by gabee View Post
Are the mysql table and your PHP program using an appropriate data type to store the encoded Chinese characters?
The data type of mysql table is ok since i can view it through phpmyadmin but i don't know wheter there is a problems with the php code . Below is the code I use :
$sql="select * from mytable where type='mytype' ";
$result=mysql_query($sql);
$name=mysql_result($result,0,"name");
echo $name;

Are there any problem with my code ?
gabee
gabee is offline
#6
Jan8-07, 11:05 PM
gabee's Avatar
P: 179
You might need to set a content-type header when you serve the webpage, to tell the browser what to do with the data.

Try inserting

<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
into the HTML of the page, or put

header('Content-Type: text/html; charset=utf-8');
before your PHP code.

Let us know if it works!
Jheriko
Jheriko is offline
#7
Jan9-07, 07:31 AM
P: 154
What do you get in place of the character. A question mark/box/placeholder? Or two seperate and apparently random characters?

The UTF-8 suggestion above will work in one case and not the other IIRC. Try other encodings if the above suggestion fails.
ngkamsengpeter
ngkamsengpeter is offline
#8
Jan10-07, 07:13 PM
P: 194
Quote Quote by Jheriko View Post
What do you get in place of the character. A question mark/box/placeholder? Or two seperate and apparently random characters?

The UTF-8 suggestion above will work in one case and not the other IIRC. Try other encodings if the above suggestion fails.
A few question marks .
I have tested gbk,big 5 and other encodings but it still not work . Please help.
Jheriko
Jheriko is offline
#9
Jan11-07, 07:15 AM
P: 154
Try UTF-16/UCS-2 whatever...

The easiest solution is to understand which encoding it is using in the first place. You should be able to find out by examining your database more thoroughly.
ngkamsengpeter
ngkamsengpeter is offline
#10
Jan11-07, 07:28 PM
P: 194
Quote Quote by Jheriko View Post
Try UTF-16/UCS-2 whatever...

The easiest solution is to understand which encoding it is using in the first place. You should be able to find out by examining your database more thoroughly.
I have examined my database and it use gbk_chinese_ci but I set encoding to gbk cannot solve the problem .How ?
Sane
Sane is offline
#11
Jan17-07, 06:43 PM
P: 223
My suggestion is... since, undoubtedly, others have run into the same problem as you have before, you should search around on Google for people that have had issues with chinese characters in MySQL databases.

The biggest issue here is you've got a problem that could be occuring on one of three different depedencies. It could be a problem with how you're storing it (MySQL), what datatype you're throwing it into (PHP), or how you're displaying it (XHTML).

I'd suggest, if you can't find out the solution by Googling for other people having the same problem, you should first eliminate the layers the problem could be sitting on. From PHP, output it to a server-side text file (with the proper encoding format) instead of HTML. If that does not work, you know the problem is in either PHP or MySQL. Keep working your way up until you have excluded the problematic area. Then, if for instance, the problem happens to be with MySQL, search the documentation for support with storing Chinese encoded characters.

Cheers,
- Sane
ngkamsengpeter
ngkamsengpeter is offline
#12
Jan23-07, 07:20 PM
P: 194
I have solved the problems ,I use "set character_connection_set=gbk,character_result_set=gbk" Anyway , thanks for yours help .
alireza55627
alireza55627 is offline
#13
Feb6-07, 12:39 AM
P: 1
Hi,
I have this problem with utf-8 character-set. I can see characters in PHPMyAdmin correctly, but in php page show ? instead characters.
Server Variables and Setting:


please help me
ngkamsengpeter
ngkamsengpeter is offline
#14
Feb13-07, 07:57 PM
P: 194
Quote Quote by alireza55627 View Post
Hi,
I have this problem with utf-8 character-set. I can see characters in PHPMyAdmin correctly, but in php page show ? instead characters.
Server Variables and Setting:


please help me
you can try to run query below first before running any query :
"set character_set_connection=utf8,character_set_result= utf8"
A-A
A-A is offline
#15
Feb16-07, 04:40 AM
P: 13
I think there are a number of possibilities you can go for, which are:

1- check to see the integrated environment you use for php + mysql is supporting chinese or not (for instance xampp software supports a number of languages and can make your life easy. I have tried mysql for persian language through xampp and it works fine).

2- If you want to use chinese characters using any php + mysql configuration, I guess you can do it, using the embeded encode and decode functions of php properly. I have stored an image into mysql database (sure, you know that mysql does not support picture formats) quite long time ago using encode and decode functions. Therefore, since garbage is garbage and the chinese characters may be presented in the garbage manner that an image is presented, you can encode your characters and view them back by your web browser upon decoding.

3- make sure your OS supports chinese fonts.
rdx
rdx is offline
#16
Feb17-07, 03:47 PM
P: 50
Quote Quote by ngkamsengpeter View Post
The data type of mysql table is ok since i can view it through phpmyadmin but i don't know wheter there is a problems with the php code . Below is the code I use :
$sql="select * from mytable where type='mytype' ";
$result=mysql_query($sql);
$name=mysql_result($result,0,"name");
echo $name;

Are there any problem with my code ?
Does echo work with name? I thought you needed print_r.
A-A
A-A is offline
#17
Feb18-07, 06:35 AM
P: 13
upon reading the first part of your reply I can conclude,

- If your phpadmin does not have any problem then you should not need any decode() or encode() mechanisms (thus, your brief code also shows that you are not using any).


Upon reaing the second part of your reply I can tell you that,

- you got problem with your code. First of all, do not give me your abstract code, give me the actual code you are using. Second, why are you retreiving the data using type as the key??!!. Third, upon getting the $result you don't need the parameter "name" in order to access the index 0 of the arry, all you need to do is call the index zero of the arry. Fourth, when you are using some text (or data) content that your are not sure of its type or it is quite large (basically larger than 250 somthing character) use the "blob" type for your field.


Register to reply