Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If you apply <code>utf8_encode()</code> to an already UTF8 string it will return a garbled UTF8 output.</p> <p>I made a function that addresses all this issues. It´s called <code>Encoding::toUTF8()</code>.</p> <p>You don't need to know what the encoding of your strings is. It can be Latin1 (iso 8859-1), Windows-1252 or UTF8, or the string can have a mix of them. <code>Encoding::toUTF8()</code> will convert everything to UTF8.</p> <p>I did it because a service was giving me a feed of data all messed up, mixing UTF8 and Latin1 in the same string.</p> <p>Usage:</p> <pre><code>require_once('Encoding.php'); use \ForceUTF8\Encoding; // It's namespaced now. $utf8_string = Encoding::toUTF8($utf8_or_latin1_or_mixed_string); $latin1_string = Encoding::toLatin1($utf8_or_latin1_or_mixed_string); </code></pre> <p>Download:</p> <p><a href="https://github.com/neitanod/forceutf8" rel="noreferrer">https://github.com/neitanod/forceutf8</a></p> <p>Update:</p> <p>I've included another function, <code>Encoding::fixUFT8()</code>, which will fix every UTF8 string that looks garbled. </p> <p>Usage:</p> <pre><code>require_once('Encoding.php'); use \ForceUTF8\Encoding; // It's namespaced now. $utf8_string = Encoding::fixUTF8($garbled_utf8_string); </code></pre> <p>Examples:</p> <pre><code>echo Encoding::fixUTF8("Fédération Camerounaise de Football"); echo Encoding::fixUTF8("Fédération Camerounaise de Football"); echo Encoding::fixUTF8("FÃÂédÃÂération Camerounaise de Football"); echo Encoding::fixUTF8("Fédération Camerounaise de Football"); </code></pre> <p>will output:</p> <pre><code>Fédération Camerounaise de Football Fédération Camerounaise de Football Fédération Camerounaise de Football Fédération Camerounaise de Football </code></pre> <p>Update: I've transformed the function (<code>forceUTF8</code>) into a family of static functions on a class called <code>Encoding</code>. The new function is <code>Encoding::toUTF8()</code>.</p>
    singulars
    1. This table or related slice is empty.
    1. PODetect encoding and make everything UTF-8
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USSebastián Grignoli
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PODetect encoding and make everything UTF-8
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThank you very much, this is exactly what I was looking for :) But it would be best to have only one single function which does everything. So forceUTF8() should include fixUTF8()'s skills.
      singulars
      1. PO
      1. UScaw
    2. COWell, if you look at the code, fixUTF8 simply calls forceUTF8 once and again until the string is returned unchanged. One call to fixUTF8() takes at least twice the time of a call to forceUTF8(), so it's a lot less performant. I made fixUTF8() just to create a command line program that would fix "encode-corrupted" files, but in a live environment is rarely needed.
      singulars
      1. PO
      1. USSebastián Grignoli
    3. COHow does this convert non-UTF8 characters to UTF8, without knowing what encoding the invalid characters are in to begin with?
      singulars
      1. PO
      1. USphilfreo
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload