0
votes
0answers
60 views

UTF-8 encoding gone missing after enabling mysqlnd

I've enabled mysqlnd on my PHP 5.4.26 server using MariaDB 10.0.8. My SQL config contained this: [mysqlnd] character-set-server = utf8 collation-server = utf8_general_ci It was all working fine ...
0
votes
1answer
80 views

Error in a collation for german characters

I would like to use the collation utf8_german2_ci in my linux server. The problem is that I want to use this character ß which is not supported in other collation I think. So I get this error ERROR ...
-1
votes
1answer
174 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 ...
0
votes
1answer
275 views

MySQl: Specified key too long ..max is 1000 bytes?

I'm trying to create a table in MySQL with the statement: CREATE TABLE tags (Tag VARCHAR(200) NOT NULL default '', Login VARCHAR(255) NOT NULL default '', PRIMARY KEY (Tag, Login)) ENGINE=MyISAM; ...
1
vote
1answer
126 views

What is the fastest way to convert MySQL columns to UTF8 from latin1 colums who's data is actually UTF8?

I have a MySQL table that has a number of columns with the latin1 character set. Because of driver issues, the columns actually contain utf8 data. I want to leave the data as-is but change the ...
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 ...
0
votes
1answer
407 views

How to read Chinese character from MySQL to PHP page by resin server?

My characters are in Chinese Simplified that stored in MySQL database by all tables and character set to UTF-8. I am reading them to my PHP page that runs under resin server on Windows XP ...
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: ...
1
vote
0answers
130 views

Adding new word characters to UTF8 encoded mySQL table for a fulltext search

I have found in the docs where it describes how to add characters to the list of word characters used during fulltext searches. My table is encoded UTF8 and from what I can see, there isn't a ...
1
vote
1answer
932 views

Importing UTF8 data into MySQL from a file causes truncation

I have a file called person.sql with 1 line: INSERT INTO Person (sFullname) VALUES ('Thomas Ågren'); If I run the following command from the shell: mysql --default-character-set=utf8 -uusername ...
9
votes
2answers
618 views

Is there a MySQL performance benchmark to measure the impact of utf8_unicode_ci versus utf8_general_ci?

I read here and there that using the utf8_unicode_ci collation ensures a better treatment of unicode text (for example, it knowns how to expand characters such as 'œ' into 'oe' for searching and ...
2
votes
2answers
481 views

Can I convert my database/script to UTF-8?

How can I convert a database to support UTF-8 and convert it's old data from what ever encoding they're in to UTF-8 ? Extra Info: I'm running a server which has many websites on it, and one of them ...
0
votes
3answers
202 views

All password with '$' inside (phpmyadmin) won't work [UTF-8 problem]

i set up a dedicaced server with a tutorial. I set in PHP : mbstring.language=UTF-8 mbstring.internal_encoding=UTF-8 mbstring.http_input=UTF-8 mbstring.http_output=UTF-8 ...
0
votes
1answer
164 views

sql and web encoding problem

Guys, I've got an encoding problem I believe. I have upgraded from phpBB2 to phpBB3. The old databases were in latin1, the new ones have utf8 encoding. Already during the upgrade process some rows ...
0
votes
3answers
1k views

how does one quote unicode characters in mysql prompt or in SQL in general?

I have a weird unicode char in my mysql database the value looks like this card issuer bank didn<U+0092>t approve your payment so what should be an apostrophe is a weird unicode char, ...
0
votes
2answers
704 views

how to set mysql to use utf8 by default?

I would like our centOS server 's mysql setup to use utf8 by default. Can you tell me which file(s) need to be configured and how? I know it's a pretty vague question but i'm not familiar with ...
1
vote
1answer
2k views

install mysql client and mysql-server with default charset utf8 to fedora 11

I only have utf8 characters to put into my db so like everything in the db is utf8. I tried 'yum install mysql mysql-server -with-charset=utf8' but it is not right. if i install using ''yum ...
5
votes
5answers
2k views

Best way to make sure a MySQL database is fully in UTF8

After some problems with UTF8 and none-UTF8 strings, we're standardising on UTF8. One thing I need to do is check that everything is in UTF8 in the MySQL database? What do I need to check? Server ...