Raised This Month: $51 Target: $400
 12% 

Utf8 characters problem


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
ecca
Sexy Santa
Join Date: Jan 2011
Old 03-25-2013 , 16:58   Utf8 characters problem
Reply With Quote #1

As the topic says, are the anyone other that have noticed this problem.

As i know you should always initialize your database with sending a utf8 request as i'm doing here.



Anyway it works well a few times as i show you below





but after like 2 minutes i stops converting the swedish utf8 characters and so on.



Why does this problem occur ?
__________________
ecca is offline
Impact123
Veteran Member
Join Date: Oct 2011
Location: Germany
Old 03-25-2013 , 22:51   Re: Utf8 characters problem
Reply With Quote #2

Are your tables utf8 too?
I guess the second screnshot is from an webinterface, how do you fetch the data there?
Give more informations please..

Yours sincerely
Impact
__________________

Last edited by Impact123; 03-25-2013 at 22:55.
Impact123 is offline
ecca
Sexy Santa
Join Date: Jan 2011
Old 03-26-2013 , 08:57   Re: Utf8 characters problem
Reply With Quote #3

Well, all screenshots except the first one is from the webinterface, but the problem is in the MySQL database that stores info because it writes wrong into there.

This is what i've tried.

Recompiling sourcecode to utf8 without bom
Changing tables to utf8_swedish and to latin_swedish_ci

temp solution is to send set names query before every other query all the time.
__________________
ecca is offline
Bacardi
Veteran Member
Join Date: Jan 2010
Location: mom's basement
Old 03-26-2013 , 10:44   Re: Utf8 characters problem
Reply With Quote #4

try convert plugin source file to UTF-8 without BOM and compile
Bacardi is offline
ecca
Sexy Santa
Join Date: Jan 2011
Old 03-26-2013 , 10:46   Re: Utf8 characters problem
Reply With Quote #5

I mentioned that above. It works fine a few minutes but then in some way it changes from utf8 to something else ?
__________________

Last edited by ecca; 03-26-2013 at 10:48.
ecca is offline
Impact123
Veteran Member
Join Date: Oct 2011
Location: Germany
Old 03-26-2013 , 11:02   Re: Utf8 characters problem
Reply With Quote #6

Well, there is encoding for (table, session, client, server and what not), all of them should be set correctly before working with the data.
So, if you have no option to alter the mysqlserver configuration i suggest you stick to the methods described here.

Yours sincerely
Impact
__________________

Last edited by Impact123; 03-26-2013 at 11:03.
Impact123 is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 19:19.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode