LinuxQuestions.org
Help answer threads with 0 replies.
Home Forums Tutorials Articles Register
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 06-24-2016, 09:49 AM   #1
ChrisVagabundo
LQ Newbie
 
Registered: May 2012
Location: Dominican Republic
Posts: 5

Rep: Reputation: Disabled
After move to a new server I have Problems with German umlauts


Status is now:

- In mysql I see the correct umlauts with phpmyadmin

- Database is utf8_general_ci

- if I read mysql and send it to a website it looks like �

- If I change the � in the browser to the correct umlaut and send it to Mysql and read it again from DB I got the correct Umlaut on the website but in mysql with phpmyadmin it looks like ü

- I have also tried to open mysql in perl with
mysql_enable_utf8 => 1
or
$dbh->{'mysql_enable_utf8'} = 1
or
$dbh->do(SET NAMES 'utf-8')
without any change.

- Websites are set to charset=utf8

- httpd.conf is set to utf8

- If I read a regulare text-file (Umlauts shown as umlauts) in the website and the umlauts changes to �

- if I change the umlauts in the textfile to ü the umlauts on the webpage are correct.

System is Centos7.

I have no idea how I can leave this hell. What can I do now?

Vagabundo
 
Old 06-24-2016, 08:14 PM   #2
frankbell
LQ Guru
 
Registered: Jan 2006
Location: Virginia, USA
Distribution: Slackware, Ubuntu MATE, Mageia, and whatever VMs I happen to be playing with
Posts: 19,324
Blog Entries: 28

Rep: Reputation: 6142Reputation: 6142Reputation: 6142Reputation: 6142Reputation: 6142Reputation: 6142Reputation: 6142Reputation: 6142Reputation: 6142Reputation: 6142Reputation: 6142
Perhaps there is a conflict between the locale settings on the computers in question.

What is the output of the locale command on the computers in question (I'm hoping that you have shell access to the server)?
 
Old 06-25-2016, 08:00 AM   #3
ChrisVagabundo
LQ Newbie
 
Registered: May 2012
Location: Dominican Republic
Posts: 5

Original Poster
Rep: Reputation: Disabled
# locale
LANG=en_US.UTF-8
LC_CTYPE="en_US.UTF-8"
LC_NUMERIC="en_US.UTF-8"
LC_TIME="en_US.UTF-8"
LC_COLLATE="en_US.UTF-8"
LC_MONETARY="en_US.UTF-8"
LC_MESSAGES="en_US.UTF-8"
LC_PAPER="en_US.UTF-8"
LC_NAME="en_US.UTF-8"
LC_ADDRESS="en_US.UTF-8"
LC_TELEPHONE="en_US.UTF-8"
LC_MEASUREMENT="en_US.UTF-8"
LC_IDENTIFICATION="en_US.UTF-8"
LC_ALL=
 
Old 06-25-2016, 09:03 PM   #4
frankbell
LQ Guru
 
Registered: Jan 2006
Location: Virginia, USA
Distribution: Slackware, Ubuntu MATE, Mageia, and whatever VMs I happen to be playing with
Posts: 19,324
Blog Entries: 28

Rep: Reputation: 6142Reputation: 6142Reputation: 6142Reputation: 6142Reputation: 6142Reputation: 6142Reputation: 6142Reputation: 6142Reputation: 6142Reputation: 6142Reputation: 6142
I'm no expert in this and certainly am not qualified to offer a solution, but I think en_US.UTF-8 might have difficulty with umlauts.

A web search led me to these articles, which might help:

https://en.wikipedia.org/wiki/UTF-8#Codepage_layout

https://www.madboa.com/geek/utf8/

https://help.ubuntu.com/community/Locale

I hope someone who has experience dealing with this issue will see this and suggest a fix.
 
  


Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
German umlauts in Java applications Lars79 Slackware 0 05-03-2006 07:45 AM
Telnet problems with Linux German Installation satishy Linux - Enterprise 2 10-28-2005 04:08 PM
Umlauts! ichbindaswalros Linux - General 1 07-02-2004 09:48 PM
WinSCP and the german umlauts (special characters like ä ö ü) Shivan Linux - Networking 0 12-15-2003 01:05 PM
German Keyboard problems marsonist Linux - General 3 04-08-2003 01:51 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 05:43 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration