And So I possess some The spanish language content held in Stand out, that i'm conveying right into a .csv format in order to import it in the Opera sql manager add-on right into a .sql db. However , after i import it, whenever there's a highlight mark, (or regardless of the technical reputation for individuals situations are) Opera does not recognize it, and accordingly creates a large black gemstone having a whitened ?. It is possible to better method of doing this? Can there be something I'm able to do in order to have my The spanish language content readable inside a sql db? Perhaps a more more suitable program compared to Opera extension? Please tell me for those who have any ideas or ideas. Thanks!

You have to stick to the chain and make certain nothing will get lost "in translation".

Particularly:

  • assert which encoding can be used within the CSV file be sure that the special charaters are effectively inside, and find out the way they are encoded (UTF8, particular Code page, ...)
  • make sure the that SQL server can
    a) read these figures and
    b) store them within an encoding that will preserve their integrity. (BTW, the encoding utilized in the CSV can obviously be remapped with a other encoding of the selecting, i.e. one you know is going to be appropriate for consumption because of your target application)
  • be sure that the database effectively saved these figures ok.
  • find out if Opera (or whichever "consumer" of the text) correctly handles figures during this encoding.

It's commonplace but helpful for this kind of queries to recommend the next reading through assignement:

The Absolute Minimum Every Software Developer Absolutely, Positively Must Know About Unicode and Character Sets (No Excuses!) by Joel Spolsky