Search tamil fonts in mysql and php

Question

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

Neither PHP nor MySQL have a GUI, and neither of them uses fonts. Your question then does not make sense. Are you asking about character sets instead? — Edgar Bonet, Oct 16 '10 at 19:42

score 1 · Answer 1 · answered May 29 '10 at 06:56

1

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.

answered May 29 '10 at 06:56

egrunin

24,650
8
50
93

I am in search of the code.If you have some example code pls post here.I will try whether it works or not. – Rekha May 29 '10 at 07:10

score 1 · Answer 2 · answered May 29 '10 at 12:10

1

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

answered May 29 '10 at 12:10

Paulraj

3,373
3
36
40

score 1 · Answer 3 · edited Jan 28 '13 at 20:51

1

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

Google Transliterate: http://www.google.com/transliterate/tamil
NHM Writer
E-kalappai

edited Jan 28 '13 at 20:51

marapet

54,856
12
170
184

answered Jun 01 '10 at 07:42

Jay Mayu

17,023
32
114
148

score 0 · Answer 4 · answered Jan 25 '13 at 17:39

0

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.

answered Jan 25 '13 at 17:39

Ashwin Balamohan

3,303
2
25
47

Search tamil fonts in mysql and php

4 Answers4