Talk in English - UK at PHP South Coast 2017
Track Name:
Spectrum IT Track
View Slides: http://rawgit.com/heiglandreas/slidedeck/master/HowToHandlePILE_OF_POO/20170609-phpsouthcoast/index_online.html
Short URL: https://joind.in/talk/60810
(QR-Code (opens in new window))
You’ve got strange characters like “�” or “ö” display in your application? Yes, handling non-English characters in application code, files and databases can be a challenge, to say the least. Whether that’s German Umlauts, Cyrillic letters, Asian Glyphs or Emojis: It’s always a mess in an international application. In this session you will see why that is and how handling characters evolved in computing. You will also see how handling characters in applications and databases can be done less painfully. And don’t worry when EBCDIC, BOM or ISO-8859-7 are Greek to you and your Unicode is a bit rusty: we’ll have a look at them too!
Comments
Comments are closed.
Excellent talk: both informative and entertaining! Learned several things I had no idea about regarding how unicode is stored and interpreted, especially regarding MySQL handling.
Cheers, Andreas! ?
A really engaging talk. Very informative with excellent slides full of useful information. The content and advice given will really help our team. Thanks Andreas
A very good and insightful talk that gave a nice overview with appropriate deeper dives into encoding and character sets in a good presentation style.
Really good talk ! Insightful !
A really great talk - well paced, informative and with good humour.
Fantastic talk that gives an overview of character encoding and how it affects the applications that we write. Also gave some great tips on how to best implement and make sure it works for our systems.
???????????
.
.
L̨̛̰̩̭̬̺͖̔̎̈́́̔͌o̭͉̰͓̤͉̣̗̓͊̂̄̈̑͢v̶̛̯͎͕̱̘̪̤͗̅͌͟͟͡ē̶̛̲̭̖̙̮̜̞͓͓̩̄́͘ḑ̸̳̬̭̦̭̲̪̾́̾́̂̅̇̚͜ t̷̠̹̘͎͊̽̃͒̏̇͜͠h̡̝̦̩̜̣͎͍͖̿̆̌̑͋ȇ̻̰̖̠͉̖̺̈́͆̃͋̎̀͞͝ t̻̹̮̯̱̥̞̲̂́̉̃̈̀̋̐͘͞a̵̢̭̯͚͉̥͕͈͗̊̓̄͡͡ĺ̴̨̡̛̙̪͙̹͚̅̈̚̚͝͝ͅk̟̬͉̱͈̯͙͍̘̒̌͒̅̈́̀̌̔͘̕,̯̞̻̭̜͔̇̊̒̚͠ g̶̨̠̜̟̗̖̀̉̓͊̋o̴͕̩̬̰̱͒̂͑̇̑̃͌o̡̤̳̗̒͗̇̀͗̃ͅd͖̻̺͓̠͈̙̫͙̉͌̑͊̅̐́ j̶̭̝̲̼̽̎̃͆͌̏̓̈́́͜͟ơ̷͉̻̜̖͖̫͑̔͋͡͞b̷͇̲̰͓̘͎̰͆͌̍̐́̑̕͟͞!̵̣̪̭̙̩͉̇̏̃̋̀͟
.
.
?
??????
Amazing speech Andreas! Learn a lot! Very useful tips on handling special chars in database! Thank you so much!
This was really interesting - a complex topic made straight-forward with great explanations, some tips for supporting unicode properly in applications (and MySQL!) and more. I look forward to putting it into practice!
Great talk. The really handy stuff for me was the MYSQL stuff.
Very enjoyable
Very informative and entertaining talk on what turns out to be a massive subject.
It's always great when speakers not only show you why you are doing things incorrectly but also how to fix things.
A very informative talk on a subject I imagine a lot of people simply gloss over or avoid. It was easy enough to follow for most parts.
It was good to find out exactly how confusing MySQL is when it comes to unicode, I hadn't realised how many places that the encoding needs to be specified and for why they need to be set.
Thanks Andreas!
Really enjoyable talk. Very educational, clearing up misconceptions and teaching me things I've always wondered about!
Really, really good talk. Well explained and presented - my understanding of character encoding is sooo much better!
Brilliant talk, thank you!
My only suggestion would be perhaps mentioning some of the problems counting glyphs, e.g. mb_strlen("??") will result in 2 (at-least as of PHP 7). In Swift 4, however, this should result in 1 as I think it uses Unicode 9 rules. What's a good tactic for accurately counting characters when emojis are involved?
Great talk. Entertaining and useful.
Great talk, for me it was the best one of the conference. Learnt a lot, and a fair amount of it is applicable to what I do & will be doing.
very good talk