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.
68
questions
54
votes
4
answers
85k
views
How to enable correct charset HTTP-header in NGINX
What is the right way to enable correct charset headers in NGINX?
I'm analyzing my website with Google Page Speed. It says that I should specify the charset of HTML files in HTTP-headers. What is the ...
- 1,080
18
votes
5
answers
116k
views
How do I change my locale to UTF-8 in CentOS?
Here's the output of locale:
LANG=zh_CN.GBK
LC_CTYPE="zh_CN.GBK"
LC_NUMERIC="zh_CN.GBK"
LC_TIME="zh_CN.GBK"
LC_COLLATE="zh_CN.GBK"
LC_MONETARY="zh_CN.GBK"
LC_MESSAGES="zh_CN.GBK"
LC_PAPER="zh_CN.GBK"
...
- 393
16
votes
2
answers
40k
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?
Komputer
11
votes
1
answer
7k
views
autoindex list UTF-8 charset in Nginx
My nginx autoindex page does not display UTF-8 characters correctly,
utf-8 problem
I have set the charset utf-8; in my server block config section of nginx.conf file but that doesn't seem to fix the ...
- 121
8
votes
5
answers
6k
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 ...
- 32.5k
7
votes
5
answers
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 ...
user22463
6
votes
2
answers
5k
views
Is there a difference between en_US.utf8 and en_US.UTF-8?
Server info (DNS and IPs removed):
cat /proc/version && uname -a && java -version
Linux version 2.6.16.33-xenU (*************) (gcc version 4.1.1 20070105 (Red Hat 4.1.1-52)) #2 SMP ...
- 167
6
votes
2
answers
50k
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 ...
- 308
5
votes
3
answers
3k
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 ...
- 391
5
votes
1
answer
642
views
Is there a legitimate reason to use an encoded word in any header other than the subject?
Encoded words allow non-US-ASCII characters to be encoded as US-ASCII and thus placed into email headers.
http://en.wikipedia.org/wiki/MIME#Encoded-Word
Encoded words are often used in the Subject ...
- 369
5
votes
2
answers
4k
views
Mount unix samba 4 share to osx client without mangled file names
I have a unix server (arch linux) with samba 4.1.12. The share has files inside it with utf-8 nfc encoding (standard utf-8).
When I mount this samba share into an osx client (10.9.5), files with ...
- 151
4
votes
3
answers
11k
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:
mysql>...
- 51
4
votes
1
answer
435
views
Is there a way to "replay" a packet capture of a smtp session for the purpose of debugging?
I'm troubleshooting a smtp issue involving character-set encoding and it's extremely difficult to involve the end user. I have a packet capture of an incoming smtp session that results in problematic ...
- 12.1k
4
votes
1
answer
965
views
Broken characters in filenames only in some directories
We have a web server running CentOS 5.8 that uses SVN for version control. When trying to switch to the latest revision, we got an error about the filenames of files in an upload directory:
svn: ...
- 205
3
votes
3
answers
42k
views
How do I make imp use right charachter set?
I am trying to import a dmp file from one database to another. The problem is that some special danish characters are not imported right because some character map conversion is done during import.
...
- 227
3
votes
2
answers
3k
views
UTF-8 Characters in Apache Access Log ✔
The issue
I'm using PHP's apache_note() to log variables from web requests to a CustomLog format. However, try as I might, Apache doesn't want to log UTF-8 characters the way I'd like.
In PHP, I ...
- 131
3
votes
2
answers
873
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 ...
- 305
3
votes
1
answer
620
views
Is it possible to serve Apache's default internal pages with charset utf-8?
This question is specifically about the charset Apache (2.2 in my case) uses when serving it's default internal pages. For example, mod_autoindex directory listings, not-found ErrorDocument pages, 500-...
- 1,436
3
votes
0
answers
1k
views
nginx reverse-proxy utf-8 not working?
I've installed Gitea on a Debian server and I'm using nginx as a reverse proxy and for the SSL setup.
When I visit my Gitea instance, some characters aren't displayed correctly. That are for example ...
user561290
3
votes
1
answer
9k
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 ...
- 164
3
votes
2
answers
3k
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.
...
- 31
2
votes
1
answer
4k
views
Apache default charset doesn't work
I am trying to set default charset to ISO-8859-1, so I added the line below into httpd.conf.
AddDefaultCharset ISO-8859-9
and I can see that value when I query it with
root@server [/]# curl -A "...
- 141
2
votes
3
answers
3k
views
Can't cd into a directory named with accented characters
I have the following folders on a CentOS 7 Droplet. They were added via FTP from a French operating system.
Evénement 1
Evénement 2
Evénement 3
The accented character (é) is replaced with a question ...
- 151
2
votes
1
answer
2k
views
Spanish Characters in Linux Server Bash Shell
I have a database that contains Spanish words in it. It contains words like sueño which have "special characters" in them. The MySQL database collation is set to utf-8-general-ci which supports ...
- 91
1
vote
1
answer
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 ...
- 281
1
vote
2
answers
2k
views
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 ...
- 212
1
vote
1
answer
3k
views
What characters are allowed for the username and password in FreeRADIUS?
I am testing the WLAN functionalities of a device connecting to a RADIUS server. This RADIUS server is located on a Raspberry Pi with Raspbian Stretch and is using FreeRADIUS 3.0 and Hostapd. For EAP-...
1
vote
1
answer
1k
views
FreeBSD 10.3 + zfs - character set incorrectly displayed in terminal
I have a server with a samba share on zfs filesystem. Filenames are in hungarian. When I login with ssh, then the file names are diplayed incorrectly in the terminal:
If I do an auto complete on the ...
- 819
1
vote
2
answers
415
views
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 ...
- 609
1
vote
1
answer
18
views
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,...
- 3,619
1
vote
1
answer
1k
views
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 ...
- 727
1
vote
0
answers
40
views
Nasty character encoding issue
I have been using a FOSS software written in perl (sql-ledger) for many many years. Currently self hosted on CentOS 7. For some reasons, I need to update OS to a higher version (preferably Rocky/Alma ...
- 11
1
vote
2
answers
367
views
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 ...
- 111
1
vote
1
answer
249
views
Varnish - usage of non latin characters of an URL in VCL
I have a client, which needs Varnish to be installed on his server. He is russian speaking and has an online shop with the following example URL, which needs to be excluded from cache (корзина is the ...
- 6,469
1
vote
2
answers
3k
views
Nginx charset directive fails to modify Content-Type header
I understand that the “charset utf-8” directive in an http or server block of a configuration file should make nginx include “Content-Type: text/html; charset=utf-8” in the headers of a response, ...
- 111
1
vote
0
answers
169
views
National characters in Open Tomato router and QNAP NAS shell
I added my Country locale (pl_PL) to shell in Open Tomato based router Asus and QNAP NAS. Originally only en_US and en_EN locale where available.
Now it is possible to use it for example in vim-full ...
- 259
1
vote
0
answers
713
views
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 ...
- 237
1
vote
0
answers
1k
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 ;charset=UTF-...
- 706
1
vote
0
answers
339
views
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 ...
- 430
1
vote
1
answer
549
views
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 ...
- 111
1
vote
0
answers
164
views
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 ...
Bahi
1
vote
1
answer
235
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 ...
- 547
0
votes
3
answers
76
views
4 unicode chars appear as first few characters in file which don't seem to show in vim
vi data.sql :
-- MariaDB dump 10.19 Distrib 10.4.28-MariaDB, for Win64 (AMD64)
But when I do head -n 10 data.sql I get the first line as
��-- MariaDB dump 10.19 Distrib 10.4.28-MariaDB, for Win64 (...
- 337
0
votes
3
answers
3k
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.) ...
- 81
0
votes
1
answer
450
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
- 377
0
votes
3
answers
12k
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 ...
- 7,918
0
votes
1
answer
1k
views
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 / {
...
0
votes
1
answer
10k
views
Serving different charsets per virtual host
On a centos Server 6.5, apache 2.2.15 is it possible to server multiple charsets to different virtual hosts?
I know that setting the default Charset is done by adding into the httpd.conf file:
...
- 129
0
votes
1
answer
1k
views
HTTP proxy to deal with different encoding [closed]
I am working on a web crawler, so I parse HTML pages. My problem is sometime the page encoding is not UTF8 (ISO, exotic Windows[0-9] etc..) and my analyser failled.
I tried many solution in PHP/Java/...
- 1,357
0
votes
1
answer
4k
views
PHP default_charset NOT changing
I have modified the php.ini file shown in the Loaded Configuration File value of phpinfo() to set the default_charset to UTF-8:
default_charset = "UTF-8"
However, when I re-run the phpinfo(), I see ...
- 167