KonaKart. Wrong character in database

Question

I installed Konakart successfully. I am using MySQL database and set utf-8 encoding. In addition I add russian language, but when I create new user and specify name with russian character in the database displayed onlly ??? signs. If I point to the database manually, everything is displayed correctly.

UPDATE

character from database displayed correctly, but some problems encoding occurred with file properties Messages.properties

See [UTF-8 all the way through](http://stackoverflow.com/a/279279). — eggyal, Dec 02 '12 at 18:08

score 0 · Accepted Answer · edited May 23 '17 at 12:18

0

I've had similar issues. First thing to do is find out what exactly has been written to the database. This is very easy with MySQL, just logon and run

SELECT HEX( column ) FROM table;

Though from what you're saying, the correct bytes are in the database already. Next thing is to check what character set your connection from Konakart is set to. After you've connected, run "SHOW VARIABLES LIKE 'character_set_%'" and print out the results. If nothing else it's a useful check to see if the character set options you've specified have taken.

This other question might be useful.

edited May 23 '17 at 12:18

Community

1
1

answered Dec 03 '12 at 08:46

chooban

9,018
2
20
36

thanks, character from database displayed correctly, but some problems encoding occurred with file properties Messages.properties – user1480528 Dec 04 '12 at 14:15

score 0 · Answer 2 · answered Oct 15 '13 at 15:44

Properties files should be saved as ISO-8859-1 files

You can add your special characters using a \uXXXX format or create a UTF-8 version of the Properties file and use native2ascii to convert it.

eg:

native2ascii -encoding utf8 myProps.utf8 myProps.properties

KonaKart. Wrong character in database

2 Answers2