small mysql prob - ? and ' - Corsa Sport - for Vauxhall and Opel Corsa B, Corsa C and Corsa D

Not logged in [Login - Register]

You Are Not Registered Or Not Logged In

Corsa Sport » Message Board » Off Day » Geek Day » small mysql prob - ? and '

New Topic

New Poll

Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.

liamC

Member

Registered: 28th Feb 04
User status: Offline

26th Apr 08 at 10:31

copying and pasting a few sentences of text from a word document into a database field, but the apostrophes keep being replaced with a ? unless i type them manually into the field.

is there a way round this?

[Edited on 26-04-2008 by liamC]

Laney

Member

Registered: 6th May 03
Location: Leeds
User status: Offline

26th Apr 08 at 18:09

MS Word uses a MS-specific character instead of '

I'm not exactly sure what it is but its similar to how it uses em-dash instead of -

Hope this helps?

colour_golden

Member

Registered: 24th Feb 08
Location: Hull - UK
User status: Offline

1st May 08 at 21:18

put a \ in front of the ' and that should be ok. the ' charachacter is used as a comment in PHP and other languages so it will kick up errors when printing out results on pages etc. You will have to escape the \ when using the results on the actual page. Not touched PHP/ASP for a about 6 months so i might be a little rusty

edit: totally read that wrong ignore me! Will leave it for others to see