language problems

lwq

I have a script which dumps my entry(blog) into the database everytime i finished typing.

I have a problem with sending asian languages into the database using this php script.

I currently do not have the script with me as my comp is down.

The script uses only simple "insert" statements to add an entry into the database.Can anyone tell me what I should do either at the db end or at the script end to solve the problem?

The asian languages I am having problem with is Chinese(both simplified and traditional).

The encoding I use for browser is UTF-8.

lwq

can anyone help me?

TobyRT

what kind of field are you posting into? is it text? varchar?

lwq

the title is using varchar,body is text

lwq

anyone? both the title, and body(main post) is displaying strange characters!

Sxooter

This is usually an encoding issue.

Can you insert these data using a straight SQL insert from the command line?

lwq

i just use a plain INSERT statement or an UPDATE statement to do the inserting of data.What should i do to the data before inserting?

lwq

Can anyone help me?

Sxooter

What I meant by my question, was, using a tool like phpmyadmin or the mysql command line interface, can you insert the characters from there?

lwq

I just went to test on my host..... i am able to insert Chinese chars into the db using phpmyadmin.What does this means?What should I do?

Sxooter

It means that phpmyadmin is using the proper character set / encoding, and your app isn't. I'd look at the header for the phpmyadmin page and see if you can find anything there. You might have to even look at the code inside phpmyadmin to see what it's doing that your code isn't.

lwq

I am using the same charset as phpmyadmin,so that means it must be something extra in the code.I notice it turns any chinese characters to &#(string of numbers), how can i do that?

lwq

can anyone please help me?

shonuff

lwq wrote:
I notice it turns any chinese characters to &#(string of numbers), how can i do that?

htmlspecialchars() ?

lwq

which charset should i use?