It may be possible to achieve this without changing the program itself, depening on what it does.
#HOW CAN I FIND WHAT MY TEXT ENCODING IS CODE#
If your programmer wrote his own conversion, and hard-coded the code pages, it is not likely that this could work.Įrland Sommarskog, SQL Server MVP, I think a better option is to investigate whether it's possible to redo the load without character-set conversion. If this is the case, changing the locale to be the same as the database, avoid this conversion. I used this Google Chrome extension and changed my encoding and tried to read webpages. (Its usually the default these days.) You may also need to check that your server is serving documents with the right HTTP declarations. Look at how broken websites can really be when the encoding is wrong.
#HOW CAN I FIND WHAT MY TEXT ENCODING IS HOW TO#
For instance, if theĬlient runs under code page CP1250 (Eastern Europe) and the target database has collation with collateon CP1252, N with actue accent, will be transferred as N. As a content author, you need to check what encoding your editor or scripts are saving text in, and how to save text in UTF-8.
![how can i find what my text encoding is how can i find what my text encoding is](http://www.steves-internet-guide.com/wp-content/uploads/int-bytes-encoding-example.jpg)
We don't even know if the columns in the target table are varchar or nvarchar.īut when you load varchar data from a client which is running under one locale with code page X and the target database has a collation with code page Y, the client API will convert characters in X that are not in Y to some fallback. It is difficult to say exactly what you should do, since we don't know exactly how things went wrong. The byte order mark is a Unicode character used to signal the endianness (byte order) of a text file or stream. Another example is the presence of the so-called Byte Order Mark (BOM) as the first character of a text file.
![how can i find what my text encoding is how can i find what my text encoding is](https://i.stack.imgur.com/Qv3Ey.jpg)
It may be possible to achieve this without changing the program itself, depening on what it does. Check out String Functions free, online, character encoder/decoder tool today. In fact the header can indicate an encoding while in reality the file is encoded with another character set. I think a better option is to investigate whether it's possible to redo the load without character-set conversion.