I have a table with some text and text is greek letters, when i use sql tool and select the data from this table is showing correctly
But when i show this my site frontend using mysql_fetch array and when echo it shows as below
Anyone know how to fix this error thank you.
If you have made sure that both the tables, and the output encoding are UTF-8, almost the only thing left is the connection encoding.
The reason for the change in behaviour when updating servers could be a change of the default connection encoding:
[mysql]
default-character-set=utf8
However, I can't see any changes in the default encoding between versions, so if those were brand-new installs, I can't see that happening.
Anyway, what happens if you run this from within your PHP query and output the results. Any differences to the command line output?
SHOW VARIABLES LIKE 'character_set%';
SHOW VARIABLES LIKE 'collation%';
Character set issues are often really tricky to figure out. Basically, you need to make sure that all of the following are true:
Here's a good tutorial on dealing with that list, from start to finish: http://www.bluebox.net/news/2009/07/mysql_encoding/
It sounds like your problem is specifically that you've got double-encoded (or triple-encoded) characters, probably from changing character sets or importing already-encoded data with the wrong charset. There's a whole section on fixing that in the above tutorial.
Wrap STRING in ` instead of '
Should be:
..AS `STRING`
And then anywhere you refer to STRING should be `STRING`
Edit: Here this should solve it:
SELECT CONCAT( PROFILE_PROFFESION, FIRST_NAME, LAST_NAME, DISPLAY_NAME) AS `STRING`
FROM `" . ACCOUNT_TABLE . "`
WHERE BUSINESS_POST_CODE LIKE '" . substr(P_BUSINESS_POST_CODE, 0, 4) . "%'"
HAVING `STRING` LIKE ( " . $data_array . " ) ;
The problem is probably that $this->phone is empty when you run the query.
In that case, the query will be SELECT * FROM [...] OR WHERE phone LIKE '%%' which will always return everything.
Solution: leave out the phone criteria if not provided or (hack alert!) use a value that will never occur in that column.
Another way to do this is changing the query to something like
SELECT *
FROM directory
WHERE name LIKE :name
AND :name_provided = 1
OR phone LIKE :phone
AND :phone_provided = 1
And then bind :phone_provided to 1 if $this->phone is defined, 0 otherwise. Likewise with :name_provided.
try the following:
after you connect to the mysql, do this query to make sure that you are using UTF8:
make sure that in HTML (head) you are using the right encoding, try:
if this does not help, try different encoding, like ISO-8859-1