Databases
StackOverflow2013
Postsdbo
POConvert utf8 to 1251
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POConvert utf8 to 1251
    primarykey
    data
    text
    <p>Okay so the problem is as follows. I have to get the information from an online form and then submit it again(changed). The page is in "windows-1251" and in my request I get it with:</p> <pre><code>{ // used to build entire input StringBuilder sb = new StringBuilder(); // used on each read operation byte[] buf = new byte[8192]; // prepare the web page we will be asking for HttpWebRequest request = (HttpWebRequest) WebRequest.Create(url); // execute the request HttpWebResponse response = (HttpWebResponse) request.GetResponse(); // we will read data via the response stream Stream resStream = response.GetResponseStream(); string tempString = null; int count = 0; do { // fill the buffer with data count = resStream.Read(buf, 0, buf.Length); // make sure we read some data if (count != 0) { // translate from bytes to ASCII text tempString = Encoding.GetEncoding(1251).GetString(buf, 0, count); // continue building the string sb.Append(tempString); } } while (count &gt; 0); // any more data to read? // print out page source // Console.WriteLine(sb.ToString()); return sb.ToString(); </code></pre> <p>So after that I strip the page and get my data into an array and I need to post it to the site again but it needs to be encoded. I use System.Net.WebUtility.UrlEncode to do the encoding but I get a completely different results from my script and from firefox(I got the original using tamper data). So any help or ideas are appreciated. BTW after I got the encoded data (from the script) I tried it online at <a href="http://www.url-encode-decode.com/" rel="nofollow">http://www.url-encode-decode.com/</a> and only UTF-8 returned the proper result. So I'm guessing I have to convert it to 1251 and I tried doing that but it was still gibberish and completely different that what it was supposed to be... So please if you can help me it will be great... :)</p> <p>Edit:</p> <pre><code>Expected: %E3%F0%E0%E4+%D1%EE%F4%E8%FF Actual: %D0%B3%D1%80%D0%B0%D0%B4+%D0%A1%D0%BE%D1%84%D0%B8%D1%8F f2[11] = град София - f2 {string[180]} string[] [0] "127.0.0.1" string [1] "1348247257" string [2] "1n132135075318435" string [3] "151669n1" string [4] "0" string [5] null string [6] null string [7] null string [8] "2" string [9] "12871449760521116" string [10] "14" string [11] "град София" string [12] "Враждебна" string [13] "42.707984,23.41341,0~бул. Ботевградско шосе" string [14] "42.7100653,23.4274006,1" string </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMarti Markov
    1. USMarti Markov
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POConvert utf8 to 1251
      1. USpaparazzo
      1. VTFavorite
    2. VO
      singulars
      1. POConvert utf8 to 1251
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIt's impossible to losslessly convert UTF-8 to 1251 because there are only ~251 possible characters for 1251 but many more for UTF-8. If you don't care about coming up with some possibly invalid strings, just treat the UTF-8 as 1252.
      singulars
      1. POConvert utf8 to 1251
      1. USSeth Carnegie
    2. COEverything is in Cyrillic so 1251 will actually do fine. If I'm not terribly wrong about something. :D
      singulars
      1. POConvert utf8 to 1251
      1. USMarti Markov
    3. COSo, `tempString` is valid string. Then you extract data from the string, and covert it to an array. Then you encode that array with `UrlEncode`. And the problem is that result of `UrlEncode` is not the expected one? Could you please edit the question, and add an example of the string, the array, the result of UrlEncode that you get, and the result that you are expecting? Four items in total.
      singulars
      1. POConvert utf8 to 1251
      1. USDialecticus
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload