File Upload Failed in mac when special chars are present

Question

We receive file content as empty in the server side when we upload file via multipart/form-data. The file name is tönt.png This happens only in Mac(any browser) not in other machines. The same file works in similar applications. The only difference is that content language header is "sv" in the former and 'en-US' in the later.

We did lot of googling, but no luck. We wonder why its not working particular OS

UPDATE: Found the cause. It seems Mac treats ö differently than windows. We see below exception in DB

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

can you show me what you have done so far, or some part of code.. — Rajnikant Sharma, May 19 '16 at 08:51
I have simple Form html which has file upload control. The form is submitted in normal POST action and form is set as multipart/form-data — Selvakumar Ponnusamy, May 19 '16 at 09:56
it may be the issue of unicode characterset, please refer this question http://stackoverflow.com/questions/18204364/php-upload-utf-8-filename — Rajnikant Sharma, May 19 '16 at 11:36
Also check the browser issue mentioned here http://blog.uploadcare.com/you-cannot-upload-files-to-a-server-using-mobile-safari/ — Rajnikant Sharma, May 19 '16 at 12:46

score 0 · Accepted Answer · answered May 20 '16 at 06:16

0

It seems Mac treats ö differently than windows. We see below error in DB logs

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

answered May 20 '16 at 06:16

Selvakumar Ponnusamy

5,363
7
40
78

File Upload Failed in mac when special chars are present

1 Answers1