Professional Web Applications Themes

Extract unicode data from MySQL db - PHP Development

Hi, I have a little, big, boring problem :) I have a utf8 txt file to import in a MySQL db, cause I must create a web-application in PHP for reading this information on-line. I have create a new DB in MYSQL 4.1.1a setting CHARACTER=utf8, then I have create a table t1 with character set utf8 and some fileds also with CHARACTER=utf8. Then I imported the Txt file (really in UTF8 format, with 22600 records!) in my db. MySQL have imported the non-utf8 field correctly, 26000 records. When I try to read this utf8 filed they appear like "???-?-???". Then, ...

  1. #1

    Default Extract unicode data from MySQL db

    Hi,

    I have a little, big, boring problem :)

    I have a utf8 txt file to import in a MySQL db, cause I must create a
    web-application in PHP for reading this information on-line.

    I have create a new DB in MYSQL 4.1.1a setting CHARACTER=utf8,
    then I have create a table t1 with character set utf8 and some fileds
    also with CHARACTER=utf8.

    Then I imported the Txt file (really in UTF8 format, with 22600
    records!) in my db. MySQL have imported the non-utf8 field correctly,
    26000 records.
    When I try to read this utf8 filed they appear like "???-?-???".

    Then, also my PHP application show this field with stranges
    characters. I have try also with PHPfunction utf8_encode with no
    success :(

    Help me

    Thank's
    JJ
    JJ Guest

  2. #2

    Default Re: Extract unicode data from MySQL db

    You're viewing the text with an editor that's doesn't support Unicode. Use a
    web browser to open the file and see what happens.

    Uzytkownik "JJ" <it> napisal w wiadomosci
    news:google.com... 


    Chung Guest

  3. #3

    Default Re: Extract unicode data from MySQL db

    "Chung Leong" <com> wrote in message news:<com>... [/ref]


    Hi,

    also with Notepad and Mozilla I can read correctly the txt file.
    I think that data are stored correctly in the DB, but PHP read it wrongly.

    :(
    JJ
    JJ Guest

Similar Threads

  1. Unicode extract:
    By cstham@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 7
    Last Post: August 11th, 03:59 AM
  2. Replies: 0
    Last Post: June 14th, 12:29 PM
  3. MySQL Extract BUG??
    By Don in forum PHP Development
    Replies: 4
    Last Post: January 6th, 01:48 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139