If I connect to my db via bash I receive the following output: | character_set_client | utf8 | I changed my my.cnf and restarted my sql server: I dropped my database and created a new one: create database db CHARACTER SET utf8 COLLATE utf8_general_ci PHP: header('Content-Type: text/html charset=utf-8') csv and importing them to Excel as UTF-8 charset (also tested all the others) results in an incorrect charset. The result was that I could read all the ä,ö,ü etc correctly inside the database. At first I didn't change anything about the charsets, I didn't use any utf8 header information. If you compress a lot of files at once, the archive takes the name know this has been discussed several times but yet I'm getting crazy dealing with this problem. The archive is created in the same location as the original file and is named originalfilename.zip. Right-click (or Ctrl-click) files you want to compress inside Finder and choose Compress Filename.Depending on which folder options that you have set, a. Your new compressed folder is displayed as a folder icon with a zipper.

Type a name for the new compressed folder, and then press ENTER.

On the File menu, point to New, and then click Compressed (zipped) Folder.

Note If you do not see a Computer (this PC) icon on your desktop, click Start, and then click My Computer (this PC). For example, if you want to make a compressed folder in the root folder of drive C, double-click Computer (this PC), and then double-click drive C to open the root folder.

On your desktop, Open Computer (this PC), and then open the folder in which you want to create the compressed folder.

Your file will retain your spreadsheet software icon, but be formatted as a. In the file name field, use the drop-down menu to select 'CSV - comma delimited'.

When you are ready to save your file, go to: File > Save As.

Type your data into the necessary cells.

csv file one must have a spreadsheet software such as Microsoft ® Excel installed on his/her computer.

csv - or Comma-Separated Value - file, is nothing more than a simplified spreadsheet.

Create csv file from excel