Jump to content

You're browsing the 2004-2023 VATSIM Forums archive. All content is preserved in a read-only fashion.
For the latest forum posts, please visit https://forum.vatsim.net.

Need to find something? Use the Google search below.
PLEASE READ - Webmaster Support Forum
This forum will be retired in the near future. Please direct all queries to our dedicated GitHub support page https://github.com/vatsimnetwork/developer-info/discussions 
Here you can find documentation on our services and we are continuing to migrate pertinent information into the Wiki pages https://github.com/vatsimnetwork/developer-info/wiki

Cert Check i18n

Luke Kolin

By Luke Kolin,
in VATSIM Webmasters

 Share

Recommended Posts

Luke Kolin

Luke Kolin

Posted
Posted

There appears to be a problem with encoding on the status check, as an example:

 

https://cert.vatsim.net/vatsimnet/idstatus.php?cid=1067774

 

Note the last name. Is this a problem with the database, or the encoding on the PHP side?

 

Cheers!

 

Luke

... I spawn hundreds of children a day. They are daemons because they are easier to kill. The first four remain stubbornly alive despite my (and their) best efforts.

... Normal in my household makes you a member of a visible minority.

Link to comment
Share on other sites
Norman Blackburn

Norman Blackburn

Posted
Posted

The registered name is Gilson Guimar?es so I guess its the character set used by them at signup.

Norman

sig_FSLBetaTester.jpg

Link to comment
Share on other sites
Luke Kolin

Luke Kolin

Posted
  • Author
Posted

Does this mean you're not encoding the names as UTF-8 in the database?

 

Cheers!

 

Luke

... I spawn hundreds of children a day. They are daemons because they are easier to kill. The first four remain stubbornly alive despite my (and their) best efforts.

... Normal in my household makes you a member of a visible minority.

Link to comment
Share on other sites
Norman Blackburn

Norman Blackburn

Posted
Posted

I personally do nothing

 

Christoph is away for a few days and should be able to answer more properly on his return.

Norman

sig_FSLBetaTester.jpg

Link to comment
Share on other sites
Daniel Gomes

Daniel Gomes

Posted
Posted

Hello,

 

That is a Portuguese character,the one not showing properlly...

 

Actually they are two. An "~" over an "a"... Whope you can see it ...

 

Without it, the name should be "Guimaraes"...

 

Cheers,

Daniel Gomes

Link to comment
Share on other sites
Miguel Frias

Miguel Frias

Posted
Posted

I'm not sure how the servers were migrated in August/September but if the code is the same then the encoding process should be the same.

Now... if the database has been CSV'ed / mysqldumped from one place to the other then this could be the problem.

 

Correct: Guimarães

Alternative: Guimaraes (without the tilde char).

 

 

Miguel

Miguel Frias

Senior Instructor (I3) & Certified Pilot (P4), ZLA I-11 graduate

Portugal vACC Training Director (ACCPT2), VATEUD Operations Director (VATEUD8)

Portugal vACC, VATEUD, VATSIM

1107190.png1107190.png

Link to comment
Share on other sites
Pedro Diogo 985361

Pedro Diogo 985361

Posted
Posted

Most of these were fine until a (presumable) migration/server change a year ago. viewtopic.php?f=68&t=53174

Pedro Diogo

Link to comment
Share on other sites
Christoph Neukirch

Christoph Neukirch

Posted
Posted

Next version of CERT will be UTF-8, sadly it will take some time 'til finished.

 

I took care of the encoding during the last server migration and I'm sure all data are in the database as before the migration. Maybe we'll find a solution to fix this, but I guess it can't be an automatic way because broken chars are broken and can't be reverted back

 

kind regards

Christoph

Link to comment
Share on other sites
Rahul Parkar

Rahul Parkar

Posted
Posted

utf8_encode(); ??

 

Did the trick for an AirCharts char issue we were having.

 

Cheers!

Rahul

Rahul Parkar

"On second thoughts Nappa, catch it, catch it with your teeth" -- Vegeta

Professional Nerd. (Professionally not professional)

Link to comment
Share on other sites
 Share
Go to topic listing