Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.php > #17760

Re: solved: Problems with accents

From Thomas 'PointedEars' Lahn <PointedEars@web.de>
Newsgroups comp.lang.php
Subject Re: solved: Problems with accents
Date 2018-05-19 20:18 +0200
Organization PointedEars Software (PES)
Message-ID <1824205.oMNUckLgyt@PointedEars.de> (permalink)
References <pdjctl$m7g$1@gioia.aioe.org> <pdmqj6$bfo$1@gioia.aioe.org> <pdn2tf$dut$1@jstuckle.eternal-september.org> <pdom4l$13eo$1@gioia.aioe.org>

Show all headers | View raw


andre <pasmoi@pasici.be> wrote:
       ^^^^^^^^^^^^^^^^

> Le 18/05/2018 19:36, Jerry Stuckle a écrit :
>> HTML is a scripting language for displaying data, not storing it.  You
>> really don't want to store the HTML equivalents in your database.  That
>> will make searching the database more complicated.  You should store the
>> characters in their natural form in the database then use
>> htmlspecialchars() or htmlentities() to display the characters.
>
> Here the problem is limited to a character you never use for searching
> the database (full text) so in my case it's a limited problem, but you
> are right better no HTML in the database.

Yes, and another reason is that it requires more space to be stored.
There are instances where one wants to store at least some markup in a 
database, but this is not one of them.

However, HTML, the HyperText Markup Language, is (as the name says, too)
a _markup_ language, _not_ a scripting language.  (The scripting languages 
that can be used in HTML include ECMAScript implementations such as 
JavaScript, which is one of my other fields of expertise.)

> Many thanks

If only you would play by the rules…

-- 
PointedEars
Zend Certified PHP Engineer <http://www.zend.com/en/yellow-pages/ZEND024953>
<https://github.com/PointedEars> | <http://PointedEars.de/wsvn>
Twitter: @PointedEars2 | Please do not cc me./Bitte keine Kopien per E-Mail.

Back to comp.lang.php | Previous | NextPrevious in thread | Next in thread | Find similar | Unroll thread


Thread

Problems with accents andre <ahr@blabla.be> - 2018-05-17 10:01 +0200
  Re: Problems with accents Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2018-05-17 12:32 +0200
    Re: Problems with accents andre <pasmoi@pasici.be> - 2018-05-17 13:36 +0200
      Re: Problems with accents Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2018-05-17 14:31 +0200
        Re: Problems with accents Jerry Stuckle <jstucklex@attglobal.net> - 2018-05-18 08:50 -0400
      Re: Problems with accents Jerry Stuckle <jstucklex@attglobal.net> - 2018-05-18 08:55 -0400
    Re: Problems with accents Jerry Stuckle <jstucklex@attglobal.net> - 2018-05-18 08:47 -0400
  Re: Problems with accents Richard Yates <richard@yatesguitar.com> - 2018-05-17 05:58 -0700
  Re: solved: Problems with accents andre <pasmoi@pasici.be> - 2018-05-18 17:13 +0200
    Re: solved: Problems with accents Jerry Stuckle <jstucklex@attglobal.net> - 2018-05-18 13:36 -0400
      Re: solved: Problems with accents andre <pasmoi@pasici.be> - 2018-05-19 10:09 +0200
        Re: solved: Problems with accents Jerry Stuckle <jstucklex@attglobal.net> - 2018-05-19 08:48 -0400
        Re: solved: Problems with accents Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2018-05-19 20:18 +0200
          Re: solved: Problems with accents Jerry Stuckle <jstucklex@attglobal.net> - 2018-05-19 18:33 -0400
            Re: solved: Problems with accents "Peter H. Coffin" <hellsop@ninehells.com> - 2018-05-20 10:44 -0500

csiph-web