MimeType

The MimeType() function returns the type of a provided file, based on its extension and the first few bytes in the file.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a text that contains the mime type of a file.

Returns Unknown if the parameter value (file) is unknown.

Common media types are listed on wikipedia.

Syntax

MimeType(file)

MimeType([PngImageFile]) 👍Result: "image/png"

MimeType([JPG-ImageFile]) 👍Result: "image/jpeg"

MimeType([CSV-File]) 👍Result: "text/csv"

MimeType([PDF-File]) 👍Result: "application/pdf"

MimeType(unknownfile) 👎Result: unknown

Parameters

Name	Type	Required	Description
file	file	☑️	a file