21293 Posts in 5733 Topics by 2602 members
| Go to End | Next > | |
| Author | Topic: | 1490 Views |
-
character set
2 February 2010 at 7:38pm
Ok I'm from Russian, and my site have different from English language, i have a problem with character set in my database, it is utf-8, and Russian simbols looks not for they must:ÃÂþòыù. In CMS and in the site it looks well, but i think it may case problems in future. How i can solve this problem?
-
Re: character set
2 February 2010 at 8:37pm
Don't worry. This is most likely a problem of the client you're using to connect to the MySQL DB.
UTF-8 encodes all characters outside the ASCII set with 2 bytes instead of one byte, so the data you see is correct, just not correctly interpreted as UTF-8 by your client software. What are you using to browse the MySQL Data? PhpMyAdmin? -
Re: character set
3 February 2010 at 1:30pm Last edited: 3 February 2010 6:26pm
Yes it case in phpMyAdmin, and when sapphire replays an error. I have modx, wordpress, and more cms and they haven't this problem, there database in phpMyAdmin is ok, so why this happens only with SS?
-
Re: character set
3 February 2010 at 8:27pm
Maybe SilverStripe doesn't set the encoding of the table correctly and assumes UTF-8 to be default? Honestly, I don't know. Did you try playing with the encoding settings in PhpMyAdmin?
Maybe a core dev could shed some light on this? -
Re: character set
3 February 2010 at 8:40pm
No i did nothing. I even reinstall cms and the database. The problem is only with Russian letters, English displays correctly.
-
Re: character set
5 February 2010 at 3:27pm
Hi Solo
give this a try an let me know
add it in mysite > _config.php
$databaseConfig["type"] = 'MySQLUnicodeDatabase';
cheers
-
Re: character set
5 February 2010 at 3:52pm Last edited: 6 February 2010 5:03pm
When i try to put this:
in my _config.php,$databaseConfig["type"] = 'MySQLUnicodeDatabase';
i get this error:Fatal error: Class 'MySQLUnicodeDatabase' not found in G:\MySites\MySite\sapphire\core\model\DB.php on line 79.
I'll try to use another from phpMyAdmin client - dbForge Studio for MySQL, so wrong letters displays there too.
When i install blog module i have ���� in tagCloud.
| 1490 Views | ||
| Go to Top | Next > |
