CODEWITHSUNDEEP
phpmysqlsearchutf-8tamil
Rekha
Rekha

Reputation: 449

Search tamil fonts in mysql and php

How do you use search a MySQL database with Tamil fonts and retrieve and display the data using PHP?

Upvotes: 2

Views: 2667

Answers (4)

Jaya Mayu
Jaya Mayu

Reputation: 17247

You need to use UTF-8 as the encoding for your MySQL DB. This allows you to later retrieve and store data to the MySQL database as you usually would.

For UTF8 Tamil input, I'd suggest you the following resources

Upvotes: 1

Ashwin Balamohan
Ashwin Balamohan

Reputation: 3332

Rekha, are your MySQL database and your PHP file encoded in UTF8?

If so, just query the DB with a string that contains Tamil characters the same way you would with any other string.

Upvotes: 0

Paulraj
Paulraj

Reputation: 3397

You should use the unicode character setup (utf8) to support multiple languages in mysql. Take a look at the example below.

Multiple Language Support - Mysql

Upvotes: 1

egrunin
egrunin

Reputation: 25053

Tamil characters are part of the Unicode spec and have been supported for years. Have you tried making a php page which takes Tamil input and stores it into the database?

If it didn't work, post your code.

Upvotes: 1

Related Questions