0
votes
0answers
30 views

How to create a new MYSQL charset?

I am trying to configure roundcube webmail and I get the error "Can't initialize character set utf8 (path: /usr/share/mysql/charsets/))" I fixed this before on my website by adding ...
0
votes
0answers
85 views

Setting default character set to UTF8 in MySQL

I followed some old thread on Stack Overflow for setting the default character set of the MySQL server to UTF8 instead of latin1. So, I made the following changes: [client] default-character-set = ...
-1
votes
1answer
193 views

filenames, ASCII unicode escaped sequences to UTF8 [closed]

I'm not sure if I've grasped the issue here so if I haven't just say so and I'll edit the title. My problem is the following: I have an Ubuntu 12.04 server (UTF-8 locale) to which users upload files ...
3
votes
1answer
503 views

Apache Web Server character encoding

I've recently transferred my webapp from my localhost (LH) to a VPS, and have had hebrew chars-encoding probs since. Whenever I send a request with a heb-char it results in "?????" saved to the DB. ...
1
vote
1answer
882 views

How to make Horde connect to mysql with UTF-8 character set?

How to tell horde 3.3.11 to use UTF-8 for it's mysql connection? The $conf['sql']['charset'] only tells horde what is expected from the database. Horde uses MDB2 to connect to mysql. Is there way to ...
0
votes
1answer
1k views

SQL Error (1064) when importing data from SQL file

I have a MySQL database, which was originally set up with the default latin1 character set and latin1_swedish_ci collation. I was using the database like this for sometime, until I noticed strange ...
3
votes
3answers
3k views

Set character_set_results UTF8 in MySQL my.cnf

how can I set the Variable character_set_results from latin1 to uft8? I thought it would be enough to add the following variable in my.cnf: default-character-set=utf8 But it not seem so: ...
3
votes
2answers
256 views

Mysql charset problem

I'm trying to import some data from one server to another. But when I do it, I'm having problems with charset. Words like Goiânia became Goiâni and conceição became conceição My Application was ...
3
votes
3answers
2k views

How to properly backup mediawiki database (mysql) without messing up the data?

I want to backup a mediawiki database stored in a MySQL server 5.1.36 using mysqldump. Most of the wiki articles are written in spanish and a don't want to mess up with it by creating the dump with ...
0
votes
1answer
363 views

how to check the charset and collation of mysql database?

how to check the charset and collation of mysql database? or what command to the charset and collation of mysql database? Thanks
0
votes
3answers
6k views

Set default MySQL connect charset for PHP (in RHEL)?

We're running a hundred or so legacy PHP websites on an older server which runs Gentoo Linux. When these sites were built latin1 was still the common charset, both in PHP and MySQL. To make sure ...
0
votes
1answer
690 views

MYSQL Collations [utf8_general_ci] and [utf8_unicode_ci]. What's the difference?

I'm wondering if there any different between these tow Collations in mysql encoding charset UTF8: utf8_general_ci and utf8_unicode_ci They both looks the same! note: For now I'm writing in them in ...
2
votes
1answer
3k views

mysql: set default charset to utf8

In an effort to set the default charset for a MySQL server to utf8, I've added the following options to my.ini character-set-server=utf8 default-collation=utf8_unicode_ci But when I start the mysql ...