Click here to Skip to main content
16,017,852 members
Home / Discussions / Linux, Apache, MySQL, PHP
   

Linux, Apache, MySQL, PHP

 
PinnedForum Guidelines - PLEASE READ PinPopular
Chris Maunder28-Jul-09 2:39
cofounderChris Maunder28-Jul-09 2:39 
Questiongreek alphabet encoding issues Pin
Member 163595595-Sep-24 3:31
Member 163595595-Sep-24 3:31 
I'm neither a PHP coder nor a DBA, barely a sysadmin 🙂

We run an old LAMP stack here which worked fine up until Debian 9 (PHP 5.6.30).
Recent migrations to Debian 10 and 12 (both PHP 5.6.40 from https://deb.sury.org) came with Greek alphabet encoding issues, not seen earlier.
These letters always looked "broken" in the database, even on Debian 9 (e.g. gamma - γ)
They displayed correctly under html in Debian 9, but not later.

Initially I thought it was:

SELECT @@character_set_database, @@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| latin1                   | latin1_swedish_ci    |

in Debian 9

vs

+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| utf8mb4                  | utf8mb4_general_ci   |

in Debian 10 and 12.

Changing it from utf8 to latin1 at different stages made no difference.

Then I thought it may be something in one of php.ini files but they are all contain:

default_charset = "UTF-8"

in the older (working) and newer (broken) stacks.

Could somebody provide a direction on how to fix it?

AnswerRe: greek alphabet encoding issues Pin
jschell7-Sep-24 3:54
jschell7-Sep-24 3:54 
Questionexample paypal payments Pin
vic5321-Mar-24 10:18
professionalvic5321-Mar-24 10:18 
Questionphp Pin
Dancane Odiwuor18-Dec-23 3:49
Dancane Odiwuor18-Dec-23 3:49 
AnswerRe: php Pin
Richard MacCutchan18-Dec-23 5:01
mveRichard MacCutchan18-Dec-23 5:01 
QuestionPHP 8.2 - Unsupported operand types: string * int Pin
Aruna KN13-Jun-23 19:48
Aruna KN13-Jun-23 19:48 
AnswerRe: PHP 8.2 - Unsupported operand types: string * int Pin
Richard MacCutchan13-Jun-23 21:10
mveRichard MacCutchan13-Jun-23 21:10 
AnswerRe: PHP 8.2 - Unsupported operand types: string * int Pin
Member 102471327-Mar-24 23:38
Member 102471327-Mar-24 23:38 
QuestionChoosing an editor Pin
jpaxtons9-Jun-23 9:48
jpaxtons9-Jun-23 9:48 
AnswerRe: Choosing an editor Pin
Deepak Vasudevan23-Aug-23 1:57
Deepak Vasudevan23-Aug-23 1:57 
QuestionFatal error: Uncaught Error: Call to a member function prepare() on null in Pin
Nicolas Veloso25-Apr-23 9:47
Nicolas Veloso25-Apr-23 9:47 
AnswerRe: Fatal error: Uncaught Error: Call to a member function prepare() on null in Pin
Richard MacCutchan25-Apr-23 9:58
mveRichard MacCutchan25-Apr-23 9:58 
Question.htaccess Query String Redirect Pin
Aruna KN20-Apr-23 5:05
Aruna KN20-Apr-23 5:05 
QuestionPHP Warning: Attempt to read property "post_content" on null Pin
Aruna KN17-Apr-23 23:09
Aruna KN17-Apr-23 23:09 
AnswerRe: PHP Warning: Attempt to read property "post_content" on null Pin
Richard MacCutchan17-Apr-23 23:59
mveRichard MacCutchan17-Apr-23 23:59 
QuestionProper parameterised queries for database access Pin
Aruna KN11-Apr-23 6:35
Aruna KN11-Apr-23 6:35 
AnswerRe: Proper parameterised queries for database access Pin
Afzaal Ahmad Zeeshan11-Apr-23 10:11
professionalAfzaal Ahmad Zeeshan11-Apr-23 10:11 
GeneralRe: Proper parameterised queries for database access Pin
Aruna KN11-Apr-23 18:25
Aruna KN11-Apr-23 18:25 
GeneralRe: Proper parameterised queries for database access Pin
Richard MacCutchan11-Apr-23 21:52
mveRichard MacCutchan11-Apr-23 21:52 
GeneralRe: Proper parameterised queries for database access Pin
Aruna KN11-Apr-23 22:13
Aruna KN11-Apr-23 22:13 
GeneralRe: Proper parameterised queries for database access Pin
Richard MacCutchan11-Apr-23 22:29
mveRichard MacCutchan11-Apr-23 22:29 
GeneralRe: Proper parameterised queries for database access Pin
Aruna KN12-Apr-23 1:34
Aruna KN12-Apr-23 1:34 
QuestionPHP Fatal error: Uncaught mysqli_sql_exception Pin
Aruna KN10-Apr-23 4:47
Aruna KN10-Apr-23 4:47 
AnswerRe: PHP Fatal error: Uncaught mysqli_sql_exception Pin
Richard MacCutchan10-Apr-23 6:04
mveRichard MacCutchan10-Apr-23 6:04 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.