| re: Extract unicode data from MySQL db
"Chung Leong" <chernyshevsky@hotmail.com> wrote in message news:<LOSdnd46Q4bZ5bTdRVn-hg@comcast.com>...[color=blue]
> 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" <dreamers_spa@yahoo.it> napisal w wiadomosci
> news:1b641cf1.0402100744.65903cb3@posting.google.c om...[color=green]
> > 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[/color][/color]
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
| 
