Server Fault Stack Exchange
Server Fault 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.

Character encoding is used to represent a repertoire of characters by some kind of encoding system. Depending on the abstraction level and context, corresponding code points and the resulting code space may be regarded as bit patterns, octets, natural numbers, electrical pulses, etc. A character encoding is used in computation, data storage, and transmission of textual data. "Character set", "character map", "codeset" and "code page" are related, but not identical, terms.

Common character encodings include

  • ASCII
  • EBCDIC
  • ISO 8859
  • Windows-1250
  • Guobiao
  • Big5
  • Unicode

Source: https://en.wikipedia.org/wiki/Character_encoding

Related tags

68 questions
1
vote
0 answers

MySQL's console client does not display non-latin symbols

I have installed mysql 5.6 on debian 7.10 from official mysql deb repository: deb http://repo.mysql.com/apt/debian/ wheezy mysql-5.6 So i have these packages installed: # dpkg -l | grep mysql | awk '{print $2 " " $3}' | column -t libdbd-mysql-perl …
hraphrap
  • 237
  • 2
  • 16
1
vote
1 answer

Mysql 5.6 client is unable show UTF8 characters

Mysql databases are hosted on AWS RDS Mysql 5.6 On one of the EC2 Cent OS 6.5 instance, I had Mysql Client 5.1. I used it to execute SELECT queries over the RDS-Mysql. There is one particular query that we do to generate a CSV file. The database…
anup
  • 717
  • 4
  • 9
  • 19
1
vote
0 answers

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 ;charset=UTF-8 to the end of the "mysql:host=" line for my db…
Dan Hastings
  • 706
  • 1
  • 13
  • 24
1
vote
0 answers

ProxyPass on httpd breaking encoding

We are sending content with multibyte character data to proxypass, which is converting the characters to %uFFFD when it hits our database. How do i prevent httpd from messing with the encoding like this?
Barry Chapman
  • 430
  • 1
  • 5
  • 17
1
vote
1 answer

Invalid umlaut characters when starting tomcat as a service

my problem is that the umlaut characters in an application pages (WAR) are not properly rendered when Tomcat is started as a service, but when I start the server manually it all looks good. I've checked the system's encoding (en_US.UTF-8) and it…
Timoteo Ponce
  • 111
  • 4
1
vote
2 answers

MySQL Table contains latin1 but is defined as UTF8, character encoding hell

I have 'inherited' an osCommerce 2.2, PHP4 and MySQL4 setup which makes trouble. The problem is the character encoding. While the tables are defined to contain UTF8 they actually contain latin1. To mix something completely new into this, it seems…
Bobby
  • 212
  • 1
  • 11
1
vote
0 answers

Need information about this HTTP header (Conexão:fechada)

I keep seeing this HTTP header in the blocked HTTP requests on my web server for a lot of separate applications: Conexão:fechada Which is in Portuguese, and it means: Connection: closed This header contains a an Illegal character by the RFC, this…
Bahi
1
vote
1 answer

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 column character set to UTF8. Every solution I've…
Daniel Beardsley
  • 547
  • 6
  • 12
1
vote
2 answers

Changing the character encoding of a MySQL database

Our whole application is now able to handle UTF-8 and it will be our choice in terms of encoding all across our architecture. The last step is to change the encoding of our MySQL databases. Of course, ALTER TABLE db_table CONVERT TO CHARACTER SET…
Julien Genestoux
  • 609
  • 8
  • 19
1
vote
2 answers

Can I usefully convert spamassassin bayes tokens from utf8 CHAR(5) to BINARY(5)?

My spamassassin setup is very old and has been migrated across two machines and multiple mysql reinstalls. I recently noticed that when running sa-learn on messages, I'd get a slew of errors like the following in my logs: bayes: _put_token: SQL…
Headbank
  • 111
  • 3
1
vote
1 answer

gmail compose adds non-visible extra characters

I have this code that works as expected in chrome browser window. This is Amazon Web Services create table statement in Athena. CREATE EXTERNAL TABLE IF NOT EXISTS default.sh_code ( `shcode` string, `mob` bigint, `c_id` int, `o_series` int, …
shantanuo
  • 3,579
  • 8
  • 49
  • 66
0
votes
3 answers

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 those older sites used latin1 by default, while still…
Martijn Heemels
  • 7,728
  • 7
  • 40
  • 64
0
votes
1 answer

phpinfo shows difference between Local and Master Values of default_charset

Here us there is a difference in the local default_charset than the master's. Is there a way to find the source of the change of each? Especially the local? So it shows the path of the file that is changing that value? My server details are: PHP…
Mike
  • 143
  • 1
  • 1
  • 3
0
votes
1 answer

How can I set mysql connection charset to utf8 in apache mod_dbd?

How can I set connection charset to utf8 in apache mod_dbd with mysql driver? I could not find any corresponding parameter in DBDParams, something like this: DBDParams…
Ehsan Khodarahmi
  • 305
  • 1
  • 7
  • 18
0
votes
1 answer

Nginx "auth_basic" string encoding

What is the right encoding/charset in nginx configuration file to display accentuated characters in HTTP authentication message ? For example, this conf file : server { ... location / { auth_basic "Zone sécurisée"; …
Klemart3D
  • 1
  • 3
1 2
3
4 5