Welcome, Guest. Please login or register.
Did you miss your activation email?
May 26, 2012, 11:47:24 PM

Login with username, password and session length
Search:     Advanced search
Interested in joining the WebsiteBaker team?
For more Information read here or on our new website.
155556 Posts in 21715 Topics by 7737 Members
Latest Member: gx-world
* Home Help Search Login Register
Pages: [1]   Go Down
Print
Author Topic: utf8 and phpmyadmin  (Read 303 times)
noname8

Offline Offline

Posts: 75


« on: December 06, 2011, 11:41:01 AM »

I have had this problem long time and it wont go away even when trying many days.
All works fine in wb, äöå and other chars works nice. But!! when opening the phmyadmin or making dump from command line, all the cyrillic chars in the table "mod_form_fields" (that dont make them htmlspecialchars) are seen messy:
Code:
ä
and the dump file is correctly utf8 wo bom

I use phpmyadmin alot and really want it to show the chars correctly also.

DETAILS:
Made all the utf-8 modifications in here:
http://www.xaranetblog.de/2008/08/02/apache-php-und-mysql-auf-utf-8-umstellen/

Mysql table of wb is: utf8_general_ci

Code:
server: Localhost via UNIX socket
server version: 5.1.37-1ubuntu5
protocol version: 10
MySQL-server charset:  UTF-8 Unicode (utf8)

Code:
Apache/2.2.12 (Ubuntu)
MySQL-customer version: 5.1.37
PHP-extension: mysqli

phpmyadmin: 3.2.2.1deb1

and variables from phpmyadmin:
http://pastebin.com/qWszTqrr

wb Version 2.8.1
Revision 1287 ( i have upgraded this from 2.7 if remember correctly, perhaps something went wrong there?)

Note:
If i edit the form field row in the phpmyadmin and put äöå in there, it displays incorrectly
note2: when added "skip-character-set-client-handshake" into my.conf all the special characters displayed incorrectly



Logged
jacobi22
Betatester
*
Offline Offline

Posts: 1376


WWW
« Reply #1 on: December 06, 2011, 01:29:02 PM »

whats your charset for the Page? (Look at Settings -> Show Advanced Options -> Charset)
Logged

LG Uwe

Wer sagt, Reichtum ist alles, hat nie ein Kind lächeln gesehen.
noname8

Offline Offline

Posts: 75


« Reply #2 on: December 07, 2011, 08:23:31 AM »

it is unicode utf-8
and my template is also utf-8 and browser detects the charset correctly.
Logged
ruebenwurzel
WebsiteBaker Org e.V.

Offline Offline

Posts: 7973



WWW
« Reply #3 on: December 07, 2011, 09:34:08 AM »

Hello,

not really shure if this has to to with the fact, that WB did not talk with the database about kollation when you store something in WB. This is in all versions of WB including 2.8.2SP2 and will hopefully fixed in a common version.

Matthias
Logged
Pages: [1]   Go Up
Print
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.16 | SMF © 2011, Simple Machines Valid XHTML 1.0! Valid CSS!