Re: Characters in an uploaded text file being corrupted

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Ok, specifically told that storage field to make use of UTF8_unicode_ci, and tried re-uploading text file that specifically saved from word using UTF8 encoding, and, the text content is still full of garbage characters..?

Suppose might try something like copying/pasting from text file in notepad, into something like a textarea field, but, don't think that would always be the perfect process in this site.

Will try a couple of other options with regard to DB encoding, and see if come right, but, let's see...

Jacob Kruger
Blind Biker
Skype: BlindZA
'...fate had broken his body, but not his spirit...'

----- Original Message ----- From: "Niel Archer" <spam-free@xxxxxxxxxxxxxxxx>
To: <php-windows@xxxxxxxxxxxxx>
Sent: Sunday, May 27, 2012 4:22 PM
Subject: Re:  Characters in an uploaded text file being corrupted


Hi

Ok, and, FWIW, this test text file is a word document that have saved as a text file, and when now resaved it using specifically unicode encoding, it
seemd to eliminate this issue,

Make sure the MySQL Db, table, field are correctly set for the encoding.
MySQL does not default to UTF-8 so you have to manually set it when
creating the Db/table. IIRC, newer versions can also have the encoding
set per field.

but would have thought there might be a
relatively simple way to handle something like encoding conversion in PHP
itself..?

PHP cannot read minds, unfortunately. There are ways to handle encoding
conversions, but I don't think anyone would call them 'simple'. ;-)
See the Multibyte String extension for one way.

--
Niel Archer


--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Database Programming]     [PHP Install]     [Kernel Newbies]     [Yosemite Forum]     [PHP Books]

  Powered by Linux