Applies to:
PHP 5.4
MySQL 5.1.4
Databases initially setup with collation 'latin1_swedish_ci'
What
Another article trying to help people display foreign characters on their website without ...
... DISTINCT
StudentDetail COLLATE Latin1_General_CS_AS
FROM
StudentTable
WHERE
SOUNDEX(StudentDetail)=SOUNDEX('Data Not Yet Available')
-- yields
StudentDetail
-----------------
Data ...
... PageID,
CONVERT(p.page_title USING latin1) AS PageTitle,
CONVERT(t.old_text USING latin1) AS PageContent,
(SELECT GROUP_CONCAT(CONVERT(wikimedia_categorylinks.cl_to USING latin1)) FROM wikimedia_categorylinks ...
... USING latin1) AS PageTitle,
CONVERT(wikimedia_text.old_text USING latin1) AS PageContent
FROM
wikimedia_page
LEFT JOIN (
wikimedia_revision, wikimedia_text)
ON
wikimedia_page.page_latest=wikimedia_revision.rev_id
WHERE ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.