Extract unicode data from MySQL db

[JJ]

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

[Chung Leong]

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" <dr**********@yahoo.it> napisal w wiadomosci
news:1b**************************@posting.google.c om...

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]

"Chung Leong" <ch***********@hotmail.com> wrote in message news:<LO********************@comcast.com>...

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" <dr**********@yahoo.it> napisal w wiadomosci
news:1b**************************@posting.google.c om...

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

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