Arabic Text Shows Encoded












0















I have a problem that file encoding was windows-1256 and it shows strange text when using ie11 and arabic text, so i changed the file encoding to utf-8 and it works fine but i need to convert back the already inserted text.



am using sql server and vb.net



this is a sample text (طھط¬ط±ط¨ط©) to be changed.










share|improve this question























  • Try something like this

    – yazanpro
    Jan 20 at 6:56











  • Encoding.Convert. windows-1256 is not a great choice as Encoding if you plan to have Web interaction. It can be used as local CodePage, but if you need to reach an international audience, it becomes a problem. windows-1256 offers poor composition for arabic letters. It should be used only locally.

    – Jimi
    Jan 20 at 8:51
















0















I have a problem that file encoding was windows-1256 and it shows strange text when using ie11 and arabic text, so i changed the file encoding to utf-8 and it works fine but i need to convert back the already inserted text.



am using sql server and vb.net



this is a sample text (طھط¬ط±ط¨ط©) to be changed.










share|improve this question























  • Try something like this

    – yazanpro
    Jan 20 at 6:56











  • Encoding.Convert. windows-1256 is not a great choice as Encoding if you plan to have Web interaction. It can be used as local CodePage, but if you need to reach an international audience, it becomes a problem. windows-1256 offers poor composition for arabic letters. It should be used only locally.

    – Jimi
    Jan 20 at 8:51














0












0








0








I have a problem that file encoding was windows-1256 and it shows strange text when using ie11 and arabic text, so i changed the file encoding to utf-8 and it works fine but i need to convert back the already inserted text.



am using sql server and vb.net



this is a sample text (طھط¬ط±ط¨ط©) to be changed.










share|improve this question














I have a problem that file encoding was windows-1256 and it shows strange text when using ie11 and arabic text, so i changed the file encoding to utf-8 and it works fine but i need to convert back the already inserted text.



am using sql server and vb.net



this is a sample text (طھط¬ط±ط¨ط©) to be changed.







c# sql asp.net vb.net






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Jan 20 at 6:47









Abdulrahman_88Abdulrahman_88

5211514




5211514













  • Try something like this

    – yazanpro
    Jan 20 at 6:56











  • Encoding.Convert. windows-1256 is not a great choice as Encoding if you plan to have Web interaction. It can be used as local CodePage, but if you need to reach an international audience, it becomes a problem. windows-1256 offers poor composition for arabic letters. It should be used only locally.

    – Jimi
    Jan 20 at 8:51



















  • Try something like this

    – yazanpro
    Jan 20 at 6:56











  • Encoding.Convert. windows-1256 is not a great choice as Encoding if you plan to have Web interaction. It can be used as local CodePage, but if you need to reach an international audience, it becomes a problem. windows-1256 offers poor composition for arabic letters. It should be used only locally.

    – Jimi
    Jan 20 at 8:51

















Try something like this

– yazanpro
Jan 20 at 6:56





Try something like this

– yazanpro
Jan 20 at 6:56













Encoding.Convert. windows-1256 is not a great choice as Encoding if you plan to have Web interaction. It can be used as local CodePage, but if you need to reach an international audience, it becomes a problem. windows-1256 offers poor composition for arabic letters. It should be used only locally.

– Jimi
Jan 20 at 8:51





Encoding.Convert. windows-1256 is not a great choice as Encoding if you plan to have Web interaction. It can be used as local CodePage, but if you need to reach an international audience, it becomes a problem. windows-1256 offers poor composition for arabic letters. It should be used only locally.

– Jimi
Jan 20 at 8:51












2 Answers
2






active

oldest

votes


















0














Did you try this



Encoding.GetEncoding(Int32)



For your Reference, Please See This Article.



https://docs.microsoft.com/en-us/dotnet/api/system.text.encoding.getencoding?view=netframework-4.7.2






share|improve this answer































    -1














    Try this:



    Database -> Properties -> Options -> Collation -> Arabic_CI_AS






    share|improve this answer

























      Your Answer






      StackExchange.ifUsing("editor", function () {
      StackExchange.using("externalEditor", function () {
      StackExchange.using("snippets", function () {
      StackExchange.snippets.init();
      });
      });
      }, "code-snippets");

      StackExchange.ready(function() {
      var channelOptions = {
      tags: "".split(" "),
      id: "1"
      };
      initTagRenderer("".split(" "), "".split(" "), channelOptions);

      StackExchange.using("externalEditor", function() {
      // Have to fire editor after snippets, if snippets enabled
      if (StackExchange.settings.snippets.snippetsEnabled) {
      StackExchange.using("snippets", function() {
      createEditor();
      });
      }
      else {
      createEditor();
      }
      });

      function createEditor() {
      StackExchange.prepareEditor({
      heartbeatType: 'answer',
      autoActivateHeartbeat: false,
      convertImagesToLinks: true,
      noModals: true,
      showLowRepImageUploadWarning: true,
      reputationToPostImages: 10,
      bindNavPrevention: true,
      postfix: "",
      imageUploader: {
      brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
      contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
      allowUrls: true
      },
      onDemand: true,
      discardSelector: ".discard-answer"
      ,immediatelyShowMarkdownHelp:true
      });


      }
      });














      draft saved

      draft discarded


















      StackExchange.ready(
      function () {
      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54274230%2farabic-text-shows-encoded%23new-answer', 'question_page');
      }
      );

      Post as a guest















      Required, but never shown

























      2 Answers
      2






      active

      oldest

      votes








      2 Answers
      2






      active

      oldest

      votes









      active

      oldest

      votes






      active

      oldest

      votes









      0














      Did you try this



      Encoding.GetEncoding(Int32)



      For your Reference, Please See This Article.



      https://docs.microsoft.com/en-us/dotnet/api/system.text.encoding.getencoding?view=netframework-4.7.2






      share|improve this answer




























        0














        Did you try this



        Encoding.GetEncoding(Int32)



        For your Reference, Please See This Article.



        https://docs.microsoft.com/en-us/dotnet/api/system.text.encoding.getencoding?view=netframework-4.7.2






        share|improve this answer


























          0












          0








          0







          Did you try this



          Encoding.GetEncoding(Int32)



          For your Reference, Please See This Article.



          https://docs.microsoft.com/en-us/dotnet/api/system.text.encoding.getencoding?view=netframework-4.7.2






          share|improve this answer













          Did you try this



          Encoding.GetEncoding(Int32)



          For your Reference, Please See This Article.



          https://docs.microsoft.com/en-us/dotnet/api/system.text.encoding.getencoding?view=netframework-4.7.2







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Feb 5 at 23:38









          Alex AbulenciaAlex Abulencia

          2113




          2113

























              -1














              Try this:



              Database -> Properties -> Options -> Collation -> Arabic_CI_AS






              share|improve this answer






























                -1














                Try this:



                Database -> Properties -> Options -> Collation -> Arabic_CI_AS






                share|improve this answer




























                  -1












                  -1








                  -1







                  Try this:



                  Database -> Properties -> Options -> Collation -> Arabic_CI_AS






                  share|improve this answer















                  Try this:



                  Database -> Properties -> Options -> Collation -> Arabic_CI_AS







                  share|improve this answer














                  share|improve this answer



                  share|improve this answer








                  edited Jan 20 at 8:49









                  Wai Ha Lee

                  5,860123964




                  5,860123964










                  answered Jan 20 at 7:58









                  MoiydMoiyd

                  5517




                  5517






























                      draft saved

                      draft discarded




















































                      Thanks for contributing an answer to Stack Overflow!


                      • Please be sure to answer the question. Provide details and share your research!

                      But avoid



                      • Asking for help, clarification, or responding to other answers.

                      • Making statements based on opinion; back them up with references or personal experience.


                      To learn more, see our tips on writing great answers.




                      draft saved


                      draft discarded














                      StackExchange.ready(
                      function () {
                      StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54274230%2farabic-text-shows-encoded%23new-answer', 'question_page');
                      }
                      );

                      Post as a guest















                      Required, but never shown





















































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown

































                      Required, but never shown














                      Required, but never shown












                      Required, but never shown







                      Required, but never shown







                      Popular posts from this blog

                      Liquibase includeAll doesn't find base path

                      How to use setInterval in EJS file?

                      Petrus Granier-Deferre