How to store hindi languge in mysql databse

[Zia_Choudhary (Zia Ur Rahman)]

See here in this thread i asked at that time about the vary same issue

[Updated 2] My sql data is not getting properly

I m working on my sql database using @Taifun method and script My tables set is like Id | Poetry And i added data like اب دلوں میں کوئی گنجائش نہیں ملتی حیاتؔ بس کتابوں میں لکھا حرف وفا رہ جائے گا (urdu poetry) When i tried to save it in text data type then when i get it in my app sometimes it mixed both id and poetry with same sorting method once i was getting text and at other time it is showing id (if u did not get my point that what i meant by sorting method then my given blo…