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.
notepad ++ shows ucs-2LE while ubuntu FILE [file] shows UTF-16LE, I am confused?
8.3k Views Asked by tough At
1
There are 1 best solutions below
Related Questions in ENCODING
- how to turn characters in wrong codec into space in python?
- erlang os:cmd() command with UTF8 binary
- How to encode bytes as a printable unicode string (like base64 for ascii)
- weird characters in utf-8 encoded file
- Enforcing that inputs sum to 1 and are contained in the unit interval in scikit-learn
- Detecting corrupt characters in UTF-8 encoded text file
- Why does opening a file in two different encodings work as expected?
- Is there any function like iconv in Python?
- Control encoding when parsing SPSS file using package memisc
- Escape XML on Windows Mobile 6
- MySQL php utf-8 format issues
- Can we convert ANSI encoded CSV file to utf-8 encoded file with javascript?
- How can I compress four floats into a string?
- Represent string as an integer in python
- Character encoding is missing at a point
Related Questions in UTF-8
- Site code to enable UTF-8 to EBCDIC encoding
- Wrong output when str_replace with acute ( ´ ) in utf-8 website
- How to encode bytes as a printable unicode string (like base64 for ascii)
- showing umlauts in html with utf8 charset
- Replace special qoutes with normal
- wxWidgets and UTF8 - some characters missing
- Detecting corrupt characters in UTF-8 encoded text file
- Control encoding when parsing SPSS file using package memisc
- Slidify no longer renders accent marks
- javascript treating special characters as utf characters
- Character encoding is missing at a point
- Search special characters with pg_search
- Hot deploying HTML templates generates question marks in the place of chinese characters - only on CentOS
- Reading from property file containing utf 8 character
- Problems with UTF8 text in XE7 ReadLn command
Related Questions in NOTEPAD++
- Open two instances of Notepad++
- Web Page Creation notepad++
- check function definition php
- Find last occurrence of string
- Switch word positions on Notepad++
- Notepad++ replace "Save" Common File Dialog Box
- Regular expressions for making uppercase accented letters
- Notepad++ Macro to open specific file
- Define word delimiter in Notepad++
- Is it possible to use notepad++ as inline text editor in eclipse
- The "Go to matching pair" feature of Emmet plugin for Notepad++
- Keyboard shortcut to jump to closing curly brace or square bracket in json view in Notepad++?
- Regular Expression (Notepad++) find all in CSV like log file where a particular column is NOT 0 or 00
- run a c++ code in notepad++
- Java : Split Sentence using unknown character?
Related Questions in UCS2
- UCS-2 enabled class 0 sms for android
- How do I convert a 16-bit UCS-2 integer value into a char?
- Check string whether is UTF-8 or UCS-2
- UCS-2 and SQL Server
- I need to get the €uro sign converted to IKw=, and it is supposed to be a base64 encoding
- How to determine in .NET if a file is UCS-2 vs. UTF-16
- Howto upload a file encoded in UCS-2 Little Endian into a Mysql table in UTF-8
- Why does SortableIntField avoid UCS-16 surrogates
- Why was the Python Unicode internal format implemented as described in PEP 100?
- SSIS tab delimited csv flat file import, import as ragged right, replaces tabs with spaces
- UCS2/HexEncoded characters
- notepad ++ shows ucs-2LE while ubuntu FILE [file] shows UTF-16LE, I am confused?
- NVARCHAR storing characters not supported by UCS-2 encoding on SQL Server
- Build a UCS-2 encoded HEX string from a Javascript default string encoding
- How to read json encoded in ibm437 in Ruby
Related Questions in UTF-16LE
- Convert UTF-16LE to UTF-8 in C
- Using `xmllint` on UTF-16 (little-endian) XML
- What to include when using Encode with PAR Packer
- UTF-16 to UTF-8 PHP conversion
- How can I convert a string to UTF-16LE and then to Base64?
- How can I read from files in UTF-16LE encoding in PHP?
- Do I have to remove the BOM by myself?
- Java UTF-16LE Weird Error That Stumped My Professor
- Unable to convert UTF-16 encoded .CSV to UTF-8 in Shiny (R)
- How to save txt file with UTF-16 LE BOM encoding in Python
- Reading a Binary File with UTF16 format
- Can UTF-16LE be converted into a MySQL LOAD DATA INFILE type format without garbling Chinese and other languages? If so how?
- notepad ++ shows ucs-2LE while ubuntu FILE [file] shows UTF-16LE, I am confused?
- Default Output File in VS Code being stored in UTF 16 LE whereas default is set to UTF-8
- PHP cannot parse CSV correctly (file is in UTF-16LE)
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
For the most part, UTF-16 and UCS-2 are the same thing. There is no difference.
What it means is that each character is two bytes wide. "LE" stands for little endian, i.e. each two-byte character is stored with the low byte first.
If you want to convert to UTF-8, in Notepad++ click
Convert to UTF-8in the Encoding menu, then save.If your other programs choke on the file after doing this, or you see two garbage characters at the start of the file, then click
Convert to UTF-8 without BOMinstead.