Chr special mysql

Ivano_Monti · August 20, 2015, 7:11pm

Hi,

I have problems with the encoding of special characters like ’ with mysql Some advice… Thank 1000

Eli_Ott · August 20, 2015, 7:58pm

What kind of problems?

Ivano_Monti · August 20, 2015, 8:47pm

characters such as accents street angel {via dell’angelo}

Matthew_Combatti · August 20, 2015, 9:01pm

Is the table UTF-8 or default Latin1? UTF-8 will support all characters.

Tim_Hare · August 20, 2015, 9:15pm

What kind of problems? Does the apostrophe cause an error in your sql? Then use a prepared statement. Do special characters display incorrectly when you read them back? Then define the encoding.

Please be specific with what you are experiencing and what you expected to happen.