News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Database Error

Started by NASA_DE, June 11, 2010, 01:43:53 PM

Previous topic - Next topic

NASA_DE

Hi Dears
When i want insert image by BB code and post in topic i got this massage.

QuoteIllegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
فایل: /home/embed/domains/embed.ir/public_html/forum/Sources/Post.php

I import my database from xampp.
I use persian language (utf8) and eng (utf8).
but i can see posted massage.
How i can solve this problem?
Thanks



CapadY

Don,t bump within 24 hours

There is a problem with your languages.
What are the setting of your database and the tables, are they also UTF-8 ?

What are the settings in your admin panel, It should also be UTF-8

In Admin - Management you can convert the database to UTF-8
Please, don't PM me for support unless invited.
If you don't understand this, you will be blacklisted.

NASA_DE

Thnaks,

How i can convert database to UTF-8?

CapadY

Admin - Maintenance - Forum Maintenance - Database

and then "Convert HTML-entities to UTF-8 characters"
Please, don't PM me for support unless invited.
If you don't understand this, you will be blacklisted.

NASA_DE

First , Thank you answer me.
__________________________
Problem not solved ,
I got massage again.  :-[
I use "Tagging System" module and when i disable that or not use for posting , everything are ok.
I don't translate this module.

Deaks

NASA_DE, do you still require assistance if so can i ask what language is your db set in
~~~~
Former SMF Project Manager
Former SMF Customizer

"For as lang as hunner o us is in life, in nae wey
will we thole the Soothron tae owergang us. In truth it isna for glory, or wealth, or
honours that we fecht, but for freedom alane, that nae honest cheil gies up but wi life
itsel."

Advertisement: