next »

[jammaster82]

Ok, im trying to organize this in my mind.   Where do i start?

the trick is that i have some data in a mysql table.

Does the encoding type matter?

The data is :

Adams County Sheriff’s Office

Thats chr(146) not chr(39) in sheriffs its like a left pointing apostrophe

So do i put a slash before that? because its
torching the insert... Do i call addslashes?
Html_entities? mysql_escape_string?

What do i have to do to be able to store/retrieve all data
in sql from php...is there a list of characters somewhere
I have to str_replace to get through? Do i Use
Magic Quotes which is now deprecated? 

[nutballs]

Yes its a quote and needs a slash in front. there are actually a boatload of those special FU characters.

Sooooooo. you have a few choices.

you can mess around with quoting and escaping.
OR
you can say screw it and encode the whole thing.

Either hexcode everything if you need to search for parts of fields.
or you can base64 encode.

If you have a need for the data to be human readable in the database, this doesnt work of course.