InMotion Hosting Support Center

How to Convert a Database to UTF-8

Category: Phplist

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

Hits: 43
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?

Support Center Login

Social Media Login

   
Social Login Joomla

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!