php-general Digest 6 Dec 2006 10:48:30 -0000 Issue 4499
Topics (messages 245542 through 245545):
Newsgroup connect time has become very long
245542 by: Al
245543 by: Al
PHP SQL Builder with JOIN support
245544 by: Kris Leech
Re: utf8 encoding £ to £ problem
245545 by: Colin Guthrie
Administrivia:
To subscribe to the digest, e-mail:
[EMAIL PROTECTED]
To unsubscribe from the digest, e-mail:
[EMAIL PROTECTED]
To post to the list, e-mail:
[email protected]
----------------------------------------------------------------------
--- Begin Message ---
Anyone having problems connecting the last few days? Or, is there something
wrong on my end. Al other sites are working just fine.
Thanks.....
--- End Message ---
--- Begin Message ---
Anyone having problems connecting the last few days? Or, is there something
wrong on my end. All other sites are working just fine.
Thanks.....
--- End Message ---
--- Begin Message ---
Does anyone know of a PHP class/function(s) which will generate SQL with
support for JOIN's to other tables.
I have used SQL Query Builder by David Regla Demaree, which is great for
simple SQL but lacks support for JOIN's.
Many thanks in advance, Kris.
--- End Message ---
--- Begin Message ---
Hi,
Chris Dean wrote:
> Just the £ and in my case I need to use that symbol, can't really get round
> it sensibly with £
I think Jochen is right about the double encoding.
The question I have to ask is where does your £ sign come from?
I can think of 3 places:
1) in the text.
2) from a DB.
3) from user input (e.g. via form).
If 1), then you can save your files as UTF8 encoded, and therefore you
just use a £ sign as normal and echo it to the user as normal, and it
will stay utf8 all the way (I presume you have utf8 charset configured
in your HTML output?)
If 2), again this can be stored either in a UTF8 charset table or in a
latin1 table and it shoudln't really matter provided your connection
charset is correct. Just use it as is.
If 3), if you pages are UTF8 encoded, the browsers /should/ (and in my
experience generally do), submit forms in utf8 encoding. Again I just
use it and don't have many problems.
So I guess the question I'm asking is why are you passing the £ symbol
through UTF8 encoding functions at all?
Col.
--- End Message ---
