Problem with special characters

[twistedsymphony]

I recently moved my forum to a new server.

I'm having a problem with special characters..... for instance when a user enters a GBP sign: £, it is written to the database as a question mark: ?

I've checked the table Collation in the database and it is exactly the same as the database on my old server.

I've tested by manually writing SQL insert into the database using these characters, and THAT works, but any inserts performed by vBulletin do no.

------------

Are there other settings I should be checking? or other tests I could perform to narrow this down. I have a lot of members from Europe so access to these special characters is important.

Thanks!

[twistedsymphony]

I'm still having this problem... Any suggestions would be greatly appreciated

[Trevor Hannant]

What's the language settings here:

AdminCP > Languages & Phrases > Language Manager

[twistedsymphony]

What's the language settings here:

AdminCP > Languages & Phrases > Language Manager

just one language: "English (US)"

[Trevor Hannant]

And what are the actual settings (language charset etc).

[twistedsymphony]

Allow User Selection: "yes"
Is Default Language: "yes"
Enable Directional Markup Fix: "no"
Text Direction: "Left to Right"
Language Code: "en"
HTML Character Set: "ISO-8859-1"

all of the Date / Time Formatting options are blank

[twistedsymphony]

I'm not sure if it's related but recently I've been getting errors like this on occasion:

Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT userid, username FROM vb_user WHERE username = '|lookup|lop|lp|lu|lurkgcabxchpwrwi6mgnio97f|luser|m_id|m_id_login|m_login|m_slogin|m_txtl ogin|m2_user_login|m4bqcyr6jf|m5login|mabru_forum|magneto_login|magneto_reglogin|maiden|ma in_login|manager|maxboarduser|mb_id_loginbox|mc1f36847ff8cee0fdb3e6a9ad187ee2e|mc7c438b0eb 3ae5edb92a73237718d4c9|mCNr|mctext|mdd368c3a8a62fb207d5375a72c8ba090|mem_user|member|membe r[login]|member_data|member_login|memberhandle|memberid|memberlogin|memblogin|meno|message_autor|m essage_login|mfo_username|mfrom|minipic|mixxtid|mlogin|mm[cu_login]|mn|mobilenumber|monmeleuh|msgby|mt_account|mulogin|muser|my_login|my_pseudo|my123un|myfre efo|mylogin|myprotect|mz|n|n_guest|n_login|n_user|n1|n7f70d3d03d154269a837cb66860e4341|naa m|nadimak|nads7f6d8sf68d7|naim|Nam|nama|namae|name1|namesave|namn|navboardlogin2|navn|navn _ytteroy|nck|ne2424a61797ee6f4de7ff73455f7a45b|negara|nei|neuer_benutzer123|nev|new_data0| new_login|new_mixxtid|new_user|newcitta|newid|newl!
ogin|newnik|newuid|newuser|newuser[login]|newuser_login|newuserid|NewUsername|nhandle|nickname|nik|nik_|nikl|nimi|nimporte|nlogin|n lpseudo|nm|nme|nNama|Nom|nom_pseudo|nombre|nombreusu|nomdusager|nome|nome_completo|nome_mi ttente|nome_usuario|nome_ut|nominativo|notice_db_user|notice_user|np|npole1|nric|nsid1|nsi d2|nu_login|nulogin|num_soc|nume|numele|nuser|nwlogin|oekakiu|offlogin|ohm_login|oink|okan test12|openid|openid_url|order[login]|Org|originator|ort|osoba|owner|p_login|p_user|p_userid|p1|p2h9d3z3u3|pa2d064789d9a4aa803a 604c9e429cd69|paidmember|Panellogin1$txSimpleLogin|partner|partner_id|partner_login|pays|p cwlogin|period|perm|person|person[login]|person_login|pets|pf_account|pf_alias|pf_aliases|pf_beruf|pf_bfnamn|pf_callsign|pf_camera |pf_chapter|pf_clickbank|pf_codnamn|pf_cognoms|pf_csnamn|pf_department|pf_favorite_song|pf _forumfall|pf_fotos_zeigen_user|pf_gamearena_id|pf_gentoo|pf_gfwl_id|pf_google_talk|pf_goo gletalk|pf_home_club|pf_imya|pf_industry|pf_ingame|pf_lastfm!
|pf_lfsworld|pf_liveforspeed|pf_livegamertag|pf_login|pf_login!
skyfi|pf_main_character|pf_mainchar|pf_member|pf_mig_id|pf_myanimelist|pf_myspace|pf_neope ts|pf_nik|pf_nik_in_game|pf_nombre_real|pf_nome|pf_openfeint|pf_orkut|pf_pers|pf_phpbb_de| pf_playstation|pf_plusid|pf_postleitzahl|pf_ps_network_usr|pf_psn|pf_psn_id|pf_psn_tag|pf_ psnid|pf_rasse|pf_rc_user|pf_referralmember|pf_referred|pf_referred_by|pf_referrer|pf_reff ered_by|pf_rsn|pf_skype|pf_steam|pf_steam_friends|pf_team|pf_tfnamn|pf_tlen|pf_tmu_login|p f_ts_user|pf_twitter|pf_twitter_id|pf_tytul|pf_user_skype|pf_user_xfi|pf_vardas|pf_version |pf_webkinzid|pf_wicnamn|pf_xbl|pf_xbltag|pf_xbox|pf_xboxlive|pf_xboxlivegamertag|pf_xfire |pf_xfire_id|pf_xfireid|pf_youtube|pg_paymate_merchant_id|phpbbsecurity_answer|phpbbsecuri ty_question|pid|pipl|pl|placed_by|player_login|plog|plogin|pokeruser|post_c_imuser|post_lo gin|post_login2|posted_by|poster|posting_user|pre_login|pref_login|premium_user|private|pr of[forum][user]|profil_login|profile[login]|profile_|profile_2|profile_fields[fid2]|prof!
ile_imya|profile_irc|profile_msn|profile_yahoo|prov|provstate|proxyuser|pseudo|pseudo_comm entaire|pseudo_cook|pseudo_post|pseudoLogin|pseudonym|psevdo|psn|publisher|puser.login|put znm|pw_login|pwdUser|pwuser|q1|qd0fe72ee20161506e5b6be4622ad31e5|quick_login|r[login]|r_basilmarket|r_geworben|r_login|r_user|r1|r7114410e68574c16abc13f0f237cec52|radioanswer3 other|rCNr|reac-titre|real|real_user_login|realtor_login|receiveinfos3|recipients|ref|referral|referredby| referrer|reg|reg.login|reg[login]|reg_handle|reg_login|reg_nome|reg_uid|reg_user|reg_user_login|regform[login]|regid|regist_login|register.login|REGISTER[LOGIN]|register_login|registerlogin|register-login|Registration$USREG_00_Login|registration[login]|reglogin|reg-login|regrealname|reguser|regusername|rejestracja_login|rememberlogin|rememberme|rememberm echeckbox|remindlogin|remoteuser|report_abuse[login]|reporter[login]|req_username|requested_login|requiredFrom|reserve_ticket[name]|result[login]|rgs_user|ricerca|rightpan!
el1:logon1:txtl|rlogin|rlogin2|rnik|room__|row[login]|rs|rs_user|rsn|ru!
_login|rulogin|ruser|s[login]|s_login|saeChapter|save_data[login]|sc5bd57ec041970f374a5ba52435543a0|scr|screen|secure|security_joomlalogin_try|send|send[login]|sender|seo_login|ser_login-tml-1|serendipity[adduser_user]|servicenumber|session[login]|session_login|session_user|set_log|set_login|setlogin|shop_user_login|short_session|sign| sign[login]|sign_login|signin[user_id]|signup|signup_user|silent_ch|site_login|site_user_login|siteuser_login|skype_id|slogin|SO METHING|spinbitz_login|splogonuser|sponsor|sql_user|sso_data[user]|sso_user_reg_login|stad|State/Province|steam[login_user]|Strasse|street|strlogin|strloginid|strreferredby|struserid|struserlogin|su_login|suggest_ cat|suggest_subcat|sun|suser|sVar[login]|swu_form_login|syslogin|system_login|szene1_login_user|t_alias|T1|T11|t11login|t1login|t2 8a58bc159b3afe19726e2375aca5c43|T3|t3r3v0|t4g5t4g2|t4user|T5|t9x9f6a2|taf_login|tb_login|t bLogin|tbuserid|tbxlogin|tcf_sender|text_0|text_1|Text1|textbox1|textbox3|textfield22|text !
Login|textn|tflogin|the_uid_is|thecakeisalie|theSig|theuser|time|titolo|tld_us|tlen|tlogin |tmp|TOKEN_LOGIN|top_login|top1$txtlogin|topic[anonymous_nick]|topicUser|tor_user|trylogin|tt1|twitter|twitter_user|tx_mmforum_pi2[userfields][7]|tx_mzgalaktyka_pi1[param1]|tx_newloginbox_pi1[firma]|tx_newloginbox_pi1[ort]|tx_newloginbox_pi1[plz]|tx_newloginbox_pi1[strasse]|tx_veguestbook_pi1[firstname]|Txt[4]|txt_captcha|txt_login|txt_loginid|txt_user|txtAlias|txthandle|txtid|txtidentity|txtLogAcc ount|txtloginid|txtmemberid|txtmorangeid|txtPrihlasovaciJmeno|txtRefer|txtskype|txtuid|txt userid|txtuserlogin|txtusuario|typekey|u|u[0][Login]|u[login]|u_l[login]|u_login|u_nm|u0jxtv91c2vybmftzqxx|u1|u989e8923454c472c116312402a74e373|ub3bbea4d1ed98d875 f29eab13da9e559|ucleftbar$ucboxlogin$txtlogin|ucmembercenter:txtlogin|ud_login|udlogin|ufi o|ufonmmme|uid|ulg|ulog|ulogin|u-login|ulogin_check|ulogin0|UN|un1|unev|unfield|unform|unm|uploader|uploaderleft|uporabnik| uprop_18|upseudo|ura|us|us_log|u!
s_login|us2_nom|use|user|user.login|user[field1]|user[login]|user[openi!
d]|user[openid_userid]|user[socialmedian_url]|user[twitter]|user_alias|user_box|user_data[user_login]|user_field_1|user_field_7|user_herkesdinlesin|user_lastfm|user_llogin|user_log|user_log[login]|user_login|user_login_2|user_login_c|user_login_id|user_login1|user_login-tml-1|user_login-tml-main|user_name|user_nazwisko|user_nik|user_now|user_referral|user_reg|user_session[login]|user_sLogin|user_user|user_usr|user_wisconsi|user0_login|user1|user2|usera|UserAccount|us erbase_login|userbreed|usercode|usercomentario|UserCompany|userdata[login]|userdata[u_id]|userData[u_login]|userdata_login|userfield[field1]|userfield[field17]|userfield[field30]|userfield[field33]|userfield[field38]|userfield[field39]|userfield[field43]|userfield[field59]|userfield[field72]|userfield[field8]|userfly|userhandle|userid|userkey|userlog|userLogin|userlogin_add|userlogin160_userid|use rlogin230_userid|usern|username|userpost|userr|userreg|userRegistration:userLogin|userRegi stration_referrer|users[log!
in]|users[txtlogin]|users_list_login|users_login|userstaemme|usertxt|userword|usid|usn|usr|usr_id|usr_login|u sr_login_enter|usr_pseudo|usrinput|usrlogin|usrmem|usuario|usuario.login|usuario_icedearth |usuario12|usulogin|utente|utilizator|utr_mem_id|uu|uuser|uvzuxpny|uzer|uzivatel|uzytkowni k|v_login|v1|v3r10u7b9s8j7|v5e505d004f4d02eec1c48c8609f71a42|v7h2t6|vad9e0dcd|val[add][login]|val[login]|validatecodeinput_login|value[person][0][login][0]|value1|var_login|var_user|vb_login_captcha|vb_login_membershipnumber|vb_login_us|vb_login _user|vb_login_username|vbc|vhodnoeimya|view_login|ville|Visitante|visitor|visitor_loc|vlo gin|von|voornaam|vorw|w_buratino|w0d395d9b704a2418f74b4288a9969f82|w3|w3user|w7a2f850bf663 ac4e59cfc5b355fcd69e|w844b5ba585305e0470f5de3a8810b415|wa98f1284abbf7927c4d12bc7d358e425|w achtwoord|webinfo|weblogin|webuser[login]|webuser_login|who|wmlogin|word_user[login]|work[contact_person]|wps.portlets.userid|write_reg|writer|ws_user|wtxtbxloginid|wu_login|wuser|x_lo!
gin|XangaHeader$txtSigninUsername|xd_16|xd_18|xfire|Xingming|xlogin|xu_!
ser|xuser|y698930571e5d236f5626b580caccda86|ya_useranonym|yahoo|yahooid|ylogin|youralias|z a706a54a6e2f7e988a742429054a9be2|zedouser|zlogin|zz|Имя|_Login|AdminLogin160_AdminID|aN|Ch angeUserData[login]|COOKIE_USER|ctl00$center$tbLogin|ctl00$ContentPlaceHolder1$tbLogin|data[Login]|data[User][login]|default_options[cp16]|default_options[cp25]|FORM[users_Login]|formLogin|formuser|frmLogin|frmlogin_login|frmlogin_turing|kQ|l48ee4c28ebd442d6d144a8cc0f 6bb5d2|Loginer1$tLogin|loginform|loginform:registrationid|loginHlp.autenticacaoTo.login|Lo ginInfo:txtPwHintAnswer|logon1:txtl|lU|M2_user_login|MB_ID_loginbox|MemberHandle|memberLog in|new_mixxtID|NEWLOGIN|newusername|panellogin1$txsimplelogin|pseudologin|pwduser|R1|Right Panel1:Logon1:txtl|something|strReferredBy|strUserID|strUserLogin|un|useraccount|USERBASE_ LOGIN|userData[login]|UserLogin160_UserID|UserLogin230_UserID|userregistration:userlogin|userregistration_refer rer|usrLogin|usuLogin|ctl00$Main$Login1$ctl00$UserCode|forgottenLogin!
|IDToken1|LOGON|phpBBSecurity_question|spLogonUser|tx_newloginbox_pi1[Firma]|tx_newloginbox_pi1[Ort]|tx_newloginbox_pi1[PLZ]|tx_newloginbox_pi1[Strasse]|txtLoginId|ucLeftBar$ucBoxLogin$txtLogin|fuser_id|ilogin|data[login][login]|txtrefer|fllogin|ctllogin:txtloginid|ctl00$wuc_login1_1$txtuserid|tblogin|formbuilderform[alias]|mcnr|rcnr|frmuserid|u[0][login]|loginlogin|default_options[cp21]|headercommon1$plogin$txusername|ctl00$center$ctl00$login|ctl00$cplpagecontent$txtlogin|tx talias|xangaheader$txtsigninusername|txtprihlasovacijmeno|t11|ctl00$tblogin|topicuser|txt[4]|lgnid|header:username|header:loginpart1:txtmembername|_ctl0:ctluserlogin1:txt_userid|svar[login]|fldlogin|header1:_ctl0:login|registration$usreg_00_login|token_login|dslogin|commentlogin |ctl00$txtuser|user_slogin|useusername|req_user|userm|lun|aimreg|yahooreg|aolid|user_ym|r_ yim|aol|api_userid|commentposter|user';

MySQL Error : Illegal mix of collations (latin1_german2_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Error Number : 1267
Request Date : Sunday, October 21st 2012 @ 12:55:40 AM
Error Date : Sunday, October 21st 2012 @ 12:55:40 AM
Script : http://collectorsedition.org/forums/...p?do=addmember
Referrer : http://collectorsedition.org/forums/register.php?
IP Address : 108.178.26.99
Username : unrenejat
Classname : vB_Database
MySQL Version :

it's always the register.php page too

[twistedsymphony]

I'm STILL having this problem and still getting errors with "Illegal mix of collations (latin1_german2_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='"

[Trevor Hannant]

You will need to use phpMyAdmin and make sure that all tables and fields within them have the same collation. Make sure your database collations are appropriate and consistent throughout the entire database. You need to use program like phpmyadmin to view your collations:

http://www.phpmyadmin.net/home_page/index.php

When you click your database name in phpmyadmin it will list all tables, their collations, as well as the collation of the database itself at the bottom. And when you click the name of a table on the left it will list the collations of individual fields within that table.

1) To edit the collation of the database itself you need to click the database name on the left and then click "Operations" on the top.

2) To edit the collation of an individual table you need to click its name on the left and then click "Operations" on the top.

3) To edit the collation of an individual field within a table you need to click the table name on the left and then click the edit image (a little pencil icon) for that field.

For more information please see: http://www.vbulletin.com/forum/showt...ight=collation

Note: It is very very very important to make full database backups before proceeding if you are ever manually making any changes to your database, let it be issuing queries, or editing it via phpMyAdmin or any other interface. If done incorrectly, manually modifying the database can potentially cause irreversible damage to your database, and there is no way to perform a "partial restore" to restore just the part you may break.

[twistedsymphony]

all of the tables within the database have the same collation, see for yourself:



all of the fields within these tables also have the same collation (forgive me if I didn't want to take screenshots off all of those tables, I did check them)