How to handle ?

Andreas Heigl (10.Jun.2017 at 13:00, 50 min)
Talk at PHP South Coast 2017 (English - UK)

Rating: 5 of 5

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!

Who are you?

Claim talk

Talk claims have been moved to the new Joind.in site.

Please login to the new site to claim your talk

 
Comments closed.

Comments

Rating: 5 of 5

10.Jun.2017 at 13:48 by Mihail Irintchev (66 comments) via Web2 LIVE

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! ?

Rating: 5 of 5

10.Jun.2017 at 13:57 by Sean Wallis (11 comments) via Web2 LIVE

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

Rating: 5 of 5

10.Jun.2017 at 15:17 by Michael Cullum (52 comments) via Web2 LIVE

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.

Rating: 5 of 5

10.Jun.2017 at 15:31 by Wim Godden (31 comments) via Web2 LIVE

Really good talk ! Insightful !

Rating: 5 of 5

10.Jun.2017 at 15:50 by Liam Wiltshire (95 comments) via joind.in Android app

A really great talk - well paced, informative and with good humour.

Rating: 5 of 5

10.Jun.2017 at 16:31 by Mark Railton (61 comments) via Web2 LIVE

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.

Rating: 5 of 5

10.Jun.2017 at 20:54 by Tim Stamp (23 comments) via Web2 LIVE

???????????
.
.
L̨̛̰̩̭̬̺͖̔̎̈́́̔͌o̭͉̰͓̤͉̣̗̓͊̂̄̈̑͢v̶̛̯͎͕̱̘̪̤͗̅͌͟͟͡ē̶̛̲̭̖̙̮̜̞͓͓̩̄́͘ḑ̸̳̬̭̦̭̲̪̾́̾́̂̅̇̚͜ t̷̠̹̘͎͊̽̃͒̏̇͜͠h̡̝̦̩̜̣͎͍͖̿̆̌̑͋ȇ̻̰̖̠͉̖̺̈́͆̃͋̎̀͞͝ t̻̹̮̯̱̥̞̲̂́̉̃̈̀̋̐͘͞a̵̢̭̯͚͉̥͕͈͗̊̓̄͡͡ĺ̴̨̡̛̙̪͙̹͚̅̈̚̚͝͝ͅk̟̬͉̱͈̯͙͍̘̒̌͒̅̈́̀̌̔͘̕,̯̞̻̭̜͔̇̊̒̚͠ g̶̨̠̜̟̗̖̀̉̓͊̋o̴͕̩̬̰̱͒̂͑̇̑̃͌o̡̤̳̗̒͗̇̀͗̃ͅd͖̻̺͓̠͈̙̫͙̉͌̑͊̅̐́ j̶̭̝̲̼̽̎̃͆͌̏̓̈́́͜͟ơ̷͉̻̜̖͖̫͑̔͋͡͞b̷͇̲̰͓̘͎̰͆͌̍̐́̑̕͟͞!̵̣̪̭̙̩͉̇̏̃̋̀͟
.
.
?
??????

Rating: 5 of 5

10.Jun.2017 at 22:31 by Luna Chen (2 comments) via Web2 LIVE

Amazing speech Andreas! Learn a lot! Very useful tips on handling special chars in database! Thank you so much!

Rating: 5 of 5

10.Jun.2017 at 22:40 by Chris Emerson (50 comments) via Web2 LIVE

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!

Rating: 5 of 5

10.Jun.2017 at 23:22 by Peter Fisher (36 comments) via Web2 LIVE

Great talk. The really handy stuff for me was the MYSQL stuff.
Very enjoyable

Rating: 5 of 5

11.Jun.2017 at 12:23 by Daniel Craigie (13 comments)

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.

Rating: 5 of 5

11.Jun.2017 at 19:23 by Lee Boynton (61 comments) via Web2 LIVE

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!

Rating: 5 of 5

12.Jun.2017 at 00:29 by Gary Jones (18 comments) via Web2 LIVE

Really enjoyable talk. Very educational, clearing up misconceptions and teaching me things I've always wondered about!

Rating: 5 of 5

12.Jun.2017 at 19:45 by Naomi Gotts (14 comments) via Web2 LIVE

Really, really good talk. Well explained and presented - my understanding of character encoding is sooo much better!

Rating: 5 of 5

12.Jun.2017 at 20:56 by Mark Dain (5 comments) via Web2 LIVE

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?

Rating: 5 of 5

12.Jun.2017 at 22:31 by Dave Liddament (67 comments) via Web2 LIVE

Great talk. Entertaining and useful.

Rating: 5 of 5

15.Jun.2017 at 23:02 by Neil Nand (46 comments) via Web2 LIVE

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.

Rating: 5 of 5

20.Jun.2017 at 09:51 by Mike Simonson (64 comments) via Web2 LIVE

very good talk

© Joind.in 2018