How to encode html to save in Mysql Database? [duplicate]

Question

I'm working on a spanish script:

I have this code in html:

<div class="details"><b>Detalle:</b> acompañado o no de una tableta digitalizadora, te permitirá¡ dar rienda suelta a tu imaginación y conseguir verdaderas obras de arte</div>

I need this output: (to save in Mysql Database)

<div class="details"><b>Detalle:</b> acompaÃ±ado o no de una tableta digitalizadora, te permitirÃ¡ dar rienda suelta a tu imaginaciÃ³n y conseguir verdaderas obras de arte</div>

any functions to do it ?

Why don't you store it in utf8? What's that second character set you're using? — Ja͢ck
– Ja͢ck, Commented Mar 12, 2013 at 6:50
all content in my database is like the html output example explained above :S — jose sanchez
– jose sanchez, Commented Mar 12, 2013 at 6:53

Sumit Bijvani · Accepted Answer · 2013-03-12 07:43:27Z

1

Change your mysql database/ table / column encoding to UTF-8 (and also set the collation to a compatible value).

ALTER TABLE mytable CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE mytable 
MODIFY country CHAR(50) 
CHARACTER SET utf8 COLLATE utf8_general_ci;

Also specify the char set at the PHP side when connecting.

mysql_set_charset('utf8',$conn);

edited Mar 12, 2013 at 7:43

answered Mar 12, 2013 at 6:53

Sumit Bijvani

8,17518 gold badges52 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vimalnath · Accepted Answer · 2013-03-12 06:58:01Z

0

mysql_real_escape_string — Escapes special characters in a string for use in an SQL statement

But that is not recommended and it's deprecated as of PHP 5.5.0.

Use this method with mysqli or PDO

edited Mar 12, 2013 at 6:58

answered Mar 12, 2013 at 6:48

Vimalnath

6,4732 gold badges28 silver badges47 bronze badges

4 Comments

Ja͢ck Over a year ago

Please, don't use mysql_* functions in new code. They are no longer maintained and are officially deprecated. See the red box? Learn about prepared statements instead, and use PDO or MySQLi - this article will help you decide which. If you choose PDO, here is a good tutorial.

Sudip Over a year ago

This extension is deprecated as of PHP 5.5.0...php.net/manual/en/function.mysql-real-escape-string.php

Vimalnath Over a year ago

@Jack Yes, i do know that. I was in the process of updating my answer. :)

Vimalnath Over a year ago

@SudipPal Yes, pls check updated/edited answer

Collectives™ on Stack Overflow

How to encode html to save in Mysql Database? [duplicate]

2 Answers 2

Comments

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Linked

Related