How to Convert a Database to UTF-8

Category: Phplist

karthej
Asked:
2014-04-11 6:04 am EST

Hits: 29
According to your reference on

http://www.inmotionhosting.com/support/website/databases/how-to-convert-a-database-to-utf-8

we followed your solution and run the php program, but this gave me the following error:


You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'character set set COLLATE hebrew_general_ci'

Please help me solving this problem

You must login before you can ask a follow up question.

You must login before you can submit an answer.

OTHER ANSWERS

0

JacobIMH
Staff
9,968 Points
2014-04-11 12:18 pm EST
Hello Karthej, and thanks for your question.

It looks like you might have possible mistyped something from our how to convert a database to UTF-8 guide.

The part of your query it seems to be complaining about is 'character set set COLLATE hebrew_general_ci'

That line should read CHARACTER SET $char_set COLLATE hebrew_general_ci" in your code.

Notice how after SET it should use the $char_set variable set at the very top of the script by default to $char_set = 'new character set'; .

It looks like you've possibly set that variable to just be set, and so your SQL query has set set COLLATE in it, instead of the correct set utf8 COLLATE hebrew_general_ci that it should.

Please let us know if that fixes your issue.

- Jacob

You must login before you can post a comment about this answer.

Like this Question?

Related Articles

It looks like there are no related articles.
Would you like to ask a question about this page? If so, click the button below!
Ask a Question

Need more Help?

Search

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail: support@InMotionHosting.com
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!