Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [charset]

Character sets are used to represent a repertoire of characters by some kind of encoding system, such as US-ASCII, ISO-8859, or UTF-8.

0
votes
3answers
2k views

character encoding: UTF8 vs iso-8859-1

I'm maintaining two generally parallel sites based on a recent release of a well-known php-based CMS. One site is in English, one in Polish. (Polish localization is a standard option for the CMS.) ...
0
votes
2answers
755 views

How to find malformed - corrupted - dos - BOMByte Files in Linux

I've several problems maintaining large production servers, in which some developers drop files from Windows environments, sometime with BOM-bytes (We use UTF8, and no need for that), causing lots of ...
3
votes
2answers
402 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 ...
2
votes
1answer
7k views

How can be changed the linux system's default character set?

I'm working in a software development team using svn. Since many developer's computers are working using windows, text file codification has to be agreed with everyone. I decided to use Linux, and ...
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
403 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
11k 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 ...
14
votes
2answers
29k views

Command to create MySQL database with Character set UTF-8

I use create database dbname; to create database. but I want it to created with Character set UTF-8 Anyone know what is the command to use?
6
votes
2answers
37k views

How do I change the default character encoding in IIS on Windows Server 2003?

When validating my web page using the W3C Validator, I noticed that although I specify ISO-8859-1 encoding in my HTML, the web server seems to be specifying UTF-8 encoding in the HTTP headers. I've ...
7
votes
5answers
7k views

Are there any disadvantages of using UTF8 in an oracle database?

We are installing ordering a configured oracle database and they are asking us what character encoding we would like to have. The application (in Java) is in English only but users are from different ...
0
votes
1answer
848 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 ...
6
votes
5answers
4k 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 ...
1
vote
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 ...