Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I think the fundamental problem here is your expectations. </p> <p>If I understand you correctly, you expect to be able to change <code>Á</code> to <code>Ã</code> by changing character encodings. That cannot happen. Those are different characters; i.e. different code points - <code>Á</code> is Unicode codepoint 00C1 (or C1 in ISO-8859-1) and <code>Ã</code> is 00C3 / C3.</p> <p>So when you transcode a <code>Á</code> in ISO-8859-1 to Unicode to UTF-8 you <em>should</em> get exactly the same character <code>Á</code>. If you don't then the translation would be broken.</p> <p><sup>You also expect <code>MÉXICO</code> to translate to <code>MÉXICO</code> ... which seems totally bizarre to me. Perhaps there's a problem in your transcription of the characters into the Question ...</sup></p> <p>Now if the lexicography rules for your language / region say that <code>Á</code> to <code>Ã</code> are actually equivalent, then it would be reasonable to "normalize" to a preferred form. However, it is not the role of the character encoding / decoding to do such locale-related translations. You need to code it yourself ... or find some other library that does it.</p> <hr> <p>Messing around at the byte level (encoding with one charset and decoding with a different one) is not going to "fix" this. If anything it is going to make things worse. Your messing around is generating byte sequences that can't be mapped to the target encoding scheme ... and hence the question marks.</p>
    singulars
    1. This table or related slice is empty.
    1. POJava; Trying to convert a String which contains ISO-8859-1 encoding to UTF-8 but file is UTF-8
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USStephen C
    1. USStephen C
    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. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThe thing is, when I get it from Input source like if I paste it to command line instead of declaring it inside the file, I do get the desired results. I know it seems strange what I need to achieve but it's a requirement from another service that's why I need it to behave that way and I thought a charset encoding and decoding would do the trick and in a way it does (I've only achieved it through input source) but I can't manage to do it from within the file.
      singulars
      1. PO
      1. USalexhg11
    2. CO@alexhg11 - I believe you are going to have to write Java code to translate individual characters as per your requirements. (But is that translation of `MÉXICO` for real? It looks bizarre ... in my browser)
      singulars
      1. PO
      1. USStephen C
    3. COApparently, it is all too bizarre to me as well, but that's how a WebService requires it to be, and that's what I'm having trouble with :/. How would I go about doing that? Do I have to do it at a byte level?
      singulars
      1. PO
      1. USalexhg11
 

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