Loading ...
Sorry, an error occurred while loading the content.

Re: Problem with DB ENCODING

Expand Messages
  • shmarafat06
    nobody knows anything about this?????!!!!!!
    Message 1 of 5 , Jul 7, 2009
    • 0 Attachment
      nobody knows anything about this?????!!!!!!
      :(:(

      --- In phpexperts@yahoogroups.com, "Mynul Islam" <mynul9280@...> wrote:
      >
      > Dear Xperts,
      >
      > Need your help again, I have 2 Db (IN BANGLA) one made in UNICODE (latin1_general_ci) AND other in UTF-8 (utf8_unicode_ci).
      >
      > Now, when I go to search something I can find the result in the UTF-8(utf8_unicode_ci) DB but Search FAILS in the OLD UNICODE (latin1_general_ci) DB.
      >
      > The ENCODING is different i can see (OLD=বরিশাল) and (New=মুন্সিà¦â€"ঞ্à¦Å") , So now How can I convert the OLD UNICODE(latin1_general_ci) DB to new UTF-8(utf8_unicode_ci) DB.
      >
      > Please ...... need urgent help!
      >
      > Advance Thanks,
      > MYNUL.
      >
    • Zakir Hossain
      use utf_encode() or use iconv/mbtring if you see this file you may guess idea how it converted non utf strings to utf:
      Message 2 of 5 , Jul 7, 2009
      • 0 Attachment
        use utf_encode()
        or use iconv/mbtring

        if you see this file you may guess idea how it converted non utf strings to utf:
        http://punbb.informer.com/svn/punbb/trunk/admin/db_update.php


        Best Regard,
        Raju
        ------------------------
        http://hungrycoder.xenexbd.com - For novice.



        On Tue, Jul 7, 2009 at 3:48 PM, shmarafat06 <shmarafat06@...> wrote:


        nobody knows anything about this?????!!!!!!
        :(:(



        --- In phpexperts@yahoogroups.com, "Mynul Islam" <mynul9280@...> wrote:
        >
        > Dear Xperts,
        >
        > Need your help again, I have 2 Db (IN BANGLA) one made in UNICODE (latin1_general_ci) AND other in UTF-8 (utf8_unicode_ci).
        >
        > Now, when I go to search something I can find the result in the UTF-8(utf8_unicode_ci) DB but Search FAILS in the OLD UNICODE (latin1_general_ci) DB.
        >
        > The ENCODING is different i can see (OLD=&#2476;&#2480;&#2495;&#2486;&#2494;&#2482;) and (New=মৠনৠসিà¦â€"ঞৠà¦Å") , So now How can I convert the OLD UNICODE(latin1_general_ci) DB to new UTF-8(utf8_unicode_ci) DB.
        >
        > Please ...... need urgent help!
        >
        > Advance Thanks,
        > MYNUL.
        >


      • Firoj Alam
        the worst solution is to get data from old db and then insert it into new db using any script eg. python. use utf8 encoding in connection string. according to
        Message 3 of 5 , Jul 7, 2009
        • 0 Attachment
          the worst solution is to get data from old db and then insert it into new db using any script eg. python. use utf8 encoding in connection string. according to your old db data it is already unicode data, so you have to read it as a utf8 and then store it as a utf8.

          Regards
          Firoj

          On Tue, Jul 7, 2009 at 8:52 PM, Zakir Hossain <rajuru@...> wrote:


          use utf_encode()
          or use iconv/mbtring

          if you see this file you may guess idea how it converted non utf strings to utf:
          http://punbb.informer.com/svn/punbb/trunk/admin/db_update.php


          Best Regard,
          Raju
          ------------------------
          http://hungrycoder.xenexbd.com - For novice.





          On Tue, Jul 7, 2009 at 3:48 PM, shmarafat06 <shmarafat06@...> wrote:


          nobody knows anything about this?????!!!!!!
          :(:(



          --- In phpexperts@yahoogroups.com, "Mynul Islam" <mynul9280@...> wrote:
          >
          > Dear Xperts,
          >
          > Need your help again, I have 2 Db (IN BANGLA) one made in UNICODE (latin1_general_ci) AND other in UTF-8 (utf8_unicode_ci).
          >
          > Now, when I go to search something I can find the result in the UTF-8(utf8_unicode_ci) DB but Search FAILS in the OLD UNICODE (latin1_general_ci) DB.
          >
          > The ENCODING is different i can see (OLD=&#2476;&#2480;&#2495;&#2486;&#2494;&#2482;) and (New=মৠনৠসিà¦â€"ঞৠà¦Å") , So now How can I convert the OLD UNICODE(latin1_general_ci) DB to new UTF-8(utf8_unicode_ci) DB.
          >
          > Please ...... need urgent help!
          >
          > Advance Thanks,
          > MYNUL.
          >





          --
          Firoj Alam
          CRBLP(Center for Research on Bangla Language Processing)
          http://www.bracuniversity.ac.bd/research/crblp/
          BRAC University, Dhaka, Bangladesh.

        Your message has been successfully submitted and would be delivered to recipients shortly.