Re: Form fields to database and back? [message #174536 is a reply to message #174534] |
Fri, 17 June 2011 01:02 |
Jerry Stuckle
Messages: 2598 Registered: September 2010
Karma:
|
Senior Member |
|
|
On 6/16/2011 8:36 PM, bobmct wrote:
> I've run into a situation where the data in a particular set of fields
> on a form contain lots and lots of special characters (they are regex
> notes for a department).
>
> The normal methods I used are failing to retrieve and display the
> original characters.
>
> My google searches come up with some rather conflicting
> recommendataions. So I thought I would ask this group.
>
> What is the most accurate technique for translating, storing,
> retrieving and properly re-displaying such fields with php and mysql?
>
> Thanks
>
It depends on what the problem is - which is why you're probably finding
conflicting answers. Your question is too vague for a meaningful answer.
First of all, it it ASCII, UTF-8 or some other character set? It does
make a difference, and you want everything (the web page, PHP and MySQL
to agree).
Second of all, how are you storing and retrieving the information? Then
how are you displaying it?
Generally, text information should be stored in the database in text
fields, using the appropriate charset and collation.
But to give you a good answer requires a lot more information.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex(at)attglobal(dot)net
==================
|
|
|