We are mining data from a website encoded using UTF-8 and we are having problems getting the data correctly in to our database.
We would like to have someone create a sample page for us that will accept foreign characters in a text box, post that to a php page that will receive the post and write the posted text to the screen correctly.? In addition, the application should write the text to a varchar (255) field in a mySQL database, read it back out and echo that to the screen.
This is a very simple working sample application so we can learn from a working sample what changes we will need to make to our application internally.
We need this to be done fast.
All pages should be encoded using UTF-8
The system shall have the following pages:
A form that allows the user to enter a string of up to 255 characters.? These characters may include foreigh characters from german, spanish, chinese japanese, etc.? I can provide sample strings if needed
This form will post to page 2:
Page 2 will echo the post received from page 1 to the screen, then insert a new record in a mySQL database table.? Once inserted, this page will jump to page 3.
Page 3 will loop through all entries in the database table and echo each string in the database on a new line.
The strings displayed on the screen should exactly match the strings originally entered on the post page.
This should be a very simple project for someone that has experience with php, mySQL and foreign character sets.