notepad ++ shows ucs-2LE while ubuntu FILE [file] shows UTF-16LE, I am confused?
===

I am trying to convert the file generated from a `mssql` to utf-8. When I open the output of he `mssql` using notepad++ in windows server 2003 recognises the file as `UCS-2LE` I copied the file to a Ubuntu machine, using `file [file]` it shows that the encoding is `UTF-16LE`. 
Really confused, there must be some difference in encoding, as the names are different. 
But why do I see this in the same file. Its a `.csv` file generated from the mssql query.  