php storing tamil in php mysql database

Question

hi everone, **njhw]wf;fpuk Muha]r]rpa[k]/ rpj]j kUj]Jt tuyhWk]

1). "hdpfSf;F ,y]yhjJ vJ> m). r";rpj fd]kk] m{). m{fhkpa fd]kk] ,). gpuhuj]jf] fd]kk] <). ,tw]wpy] vJt[kpy]iy.

2). ‘,iwtdpy] ,Ue]jy]y/ khiaapy] ,Ue]J jhd; cyfk] cw]gj;jpahfpd;wJ’ – ahh] bfhs]if m). irt-rpe]jhe;jpfs; m{). m{rPtfthjpfs; ,). rkzh]fs; <). ntjhe]jpfs;. **

The above ia typed in tamil-aishwarya font.

I need to know how to store it in php mysql database

Plz reply if anyone know the answer

Answer 1

Here's a tutorial that goes into this.

Answer 2

You may need the unicode support. http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html

Answer 3

Just store it as such? A database in the end stores bits. It won't store the font used to display those bits. You will get the same bits out when you ask later, and at that time you can reuse the same font.

Of course, a more sensible solution in general is the use of Unicode, but I understand that the Unicode people and Tamil aren't really getting along well.

Answer 4

If you have it in font types such as TAB, TAM etc, First you have to convert it into Unicode. You can do that here: http://www.jaffnalibrary.com/tools/Unicode.htm

Also, You have set up the character set of your tables or fields to Unicode.

Answer 5

Basically you need to set-up your DB to store UTF-8 strings and then save your work in Unicode.. dont try fonts like Bamini. Now Unicode is widely accepted standard.