Help!
How do I get special characters to convert correctly when inserting
and reading from my database.
For example.
é = eacute;
ë = euml;
I keep getting
ë and é
using htmlentities, htmlspecialchars, etc...
Any pointers? Please!
Going bald over here.
here is my funcitons
function
On Aug 9, 2012, at 5:37 AM, Karl DeSaulniers wrote:
Help!
How do I get special characters to convert correctly when inserting
and reading from my database.
For example.
é = eacute;
ë = euml;
I keep getting
ë and é
using htmlentities, htmlspecialchars, etc...
Any pointers? Please!
On Aug 9, 2012, at 5:41 AM, Karl DeSaulniers wrote:
On Aug 9, 2012, at 5:37 AM, Karl DeSaulniers wrote:
Help!
How do I get special characters to convert correctly when inserting
and reading from my database.
For example.
é = eacute;
ë = euml;
I keep getting
ë and é
using
Not sure if this will work any better, but have you tried using
htmlspecialchars instead of htmlentities?
http://www.php.net/manual/en/function.htmlspecialchars.php
You should also use mysql*i*_real_escape_string instead of the older (and
deprecated) mysql_real_escape_string. When you use the
No one?
Not even a link I can go look this up myself with?
I have successfuly converted before, but this time the company
is in the netherlands and their special characters are doing this.
Also, I have the database set to UTF-8, but when I check the charset:
$charset =
-Original Message-
From: Karl DeSaulniers [mailto:k...@designdrumm.com]
Sent: Thursday, August 09, 2012 10:19 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] convert special characters.
On Aug 9, 2012, at 5:41 AM, Karl DeSaulniers wrote:
On Aug 9, 2012, at 5:37 AM, Karl
Hey anything is better than nothing. Thanks for the effort.
I will investigate this further. Did not know mysql_real_escape_string
was depreciated.
Good to know.
Thank you!
Best,
Karl
On Aug 9, 2012, at 4:30 PM, Graham H. wrote:
Not sure if this will work any better, but have you tried
On Aug 9, 2012, at 5:02 PM, Govinda wrote:
No one?
Not even a link I can go look this up myself with?
I have successfuly converted before, but this time the company
is in the netherlands and their special characters are doing this.
Also, I have the database set to UTF-8, but when I check the
On Aug 9, 2012, at 5:08 PM, Toby Hart Dyke wrote:
-Original Message-
From: Karl DeSaulniers [mailto:k...@designdrumm.com]
Sent: Thursday, August 09, 2012 10:19 PM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] convert special characters.
On Aug 9, 2012, at 5:41 AM, Karl
On Aug 9, 2012, at 6:14 PM, Govinda wrote:
I believe when the table was set up.
This was handed off from others.
I will ask. Thanks for the heads up on the difference.
notice there are also these if you end up needing them:
iconv_set_encoding()
iconv()
notice there are also these if you end up needing them:
iconv_set_encoding()
iconv()
http://us.php.net/manual/en/function.iconv-set-encoding.php
http://us.php.net/manual/en/function.iconv.php
-Govinda
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit:
On Aug 9, 2012, at 6:33 PM, Govinda wrote:
notice there are also these if you end up needing them:
iconv_set_encoding()
iconv()
http://us.php.net/manual/en/function.iconv-set-encoding.php
http://us.php.net/manual/en/function.iconv.php
-Govinda
--
PHP Database Mailing List
They are getting converted in those functions I posted.
They display correctly when in the text field, but when inserted to the DB by
that functions, they get converted.
Then when I echo them out of the DB they are the converted chars.
I think it may be the table or table cell, but I read
On Aug 9, 2012, at 8:20 PM, Govinda wrote:
They are getting converted in those functions I posted.
They display correctly when in the text field, but when inserted to
the DB by that functions, they get converted.
Then when I echo them out of the DB they are the converted chars.
I think it
14 matches
Mail list logo