Re: Placing html entities into database?
| From: | Viacheslav Kaloshin | Date: | Tue, 08 Feb 2005 10:37:58 +0000 |
| Subject: | Re: Placing html entities into database? | ||
| References: | 1 2 3 4 5 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-38516@lists.php.net to get a copy of this message | ||
On Tue, 08 Feb 2005 11:30:19 +0100, Merlin <news.groups@web.de> wrote:
> > Only one: if you plan to use more, than one character set. Say, you
> > want store in one column text with greek, german, italian and chineese
> > characters ;-)
>
> The same column should hold english and german text. Acording to your reply this
> seems fine since there are no special characters in english?!
You are absolutely right ;-)
>
> Thanx, Merlin
>
>
> Viacheslav Kaloshin wrote:
> > On Tue, 08 Feb 2005 10:54:33 +0100, Merlin <news.groups@web.de> wrote:
> >
> >>>1 - use latest versions (4.1) of mysql and UTF-8 encoding.
> >>
> >>I am using 4.0.18 and the data look korrekt when retriefed out of the database.
> >>I did not enable any kind of encodeing. Is there a downfall in how I am doing
> >>it, which I just now do not notice?
> >
> >
> > Only one: if you plan to use more, than one character set. Say, you
> > want store in one column text with greek, german, italian and chineese
> > characters ;-)
> >
> > But if only one character set and no plans to extend - no problem to
> > use "as is" without any reencoding
> >
> >
> >>Regards,
> >>
> >>Merlin
> >>
> >>
> >>
> >>>2(bad) - before storing encode all string to base64 or something like this :-)
> >>>
> >>>On Tue, 08 Feb 2005 10:29:20 +0100, Merlin <news.groups@web.de> wrote:
> >>>
> >>>
> >>>>Hi there,
> >>>>
> >>>>I am wondering how to store special characters like the german ö for example
> >>>>into a mysql db. Should the characters somehow be transforemd into html
> >>>>entities
> >>>>like ö? What are the benefits if it works without them as well?
> >>>>
> >>>>Thank you for any hint,
> >>>>
> >>>>Merlin
> >>>>
> >>>>--
> >>>>PHP Database Mailing List (http://www.php.net/)
> >>>>To unsubscribe, visit:
> >>>>http://www.php.net/unsub.php
> >>>>
> >>>>
> >>
> >>--
> >>PHP Database Mailing List (http://www.php.net/)
> >>To unsubscribe, visit: http://www.php.net/unsub.php
> >>
> >>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>