A community in which webmasters can ask for help with topics such as PHP coding , MySQL , IT jobs, web design, IT security.
Current location:homephp forumphp talk in 2008 yearMySQL and PHP unicode problems - page 1
User InfoPosts
MySQL and PHP unicode problems#1
I have the following UTF-8 file exported from a microsoft access file


I have ensured my mysql database is utf8 with the status; command for both client and server. I insert the above file into my database with the following command:


All seems to be going kind of OK, unicode characters are displayed in the html as they should be as far as I can tell. The direct contents of the database field is here:


However the resulting html code is displayed:


Which displays as

Fee Listing


in the browser

The code I am using to show this is:


which was working fine before I changed the encoding.

as a side question, I am wondering why changing from tab delimited to semicolon delimited, and enclosing fields would ddecrease the size of the exported file by half. The tab character is a single character just like the ; character, and adding quotes to enclose should have increased the size?

posted date: 2008-12-10 04:32:00

Re: MySQL and PHP unicode problems#2
I had made out the solution of this problem. click to view my topic...

hope that hepls.

posted date: 2008-12-10 04:32:01

Re: MySQL and PHP unicode problems#3
Depending on the configuration of the web server you may need to explicitly set the encoding to "text/html; charset=UTF-8", with header():header('Content-Type: text/html; charset=UTF-8');This should be enough for your specific problem, but - in case you also intend to manipulate the strings - note that PHP contains many functions that are not safe to use with multi-byte characters: you should at least properly configure the mbstring extension.I also have this cheatsheet in my bookmarks, I think it's still relevant.

posted date: 2008-12-10 05:58:00

Re: MySQL and PHP unicode problems#4
That did not seem to fix anything, is it possibly a problem with the database? It seems to be a problem with the html meant to be passed to document.write, and a tag unclosed somewhere.

posted date: 2008-12-11 05:12:00

select page: « 1 »
Copyright ©2008-2017 www.momige.com, all rights reserved.