MySql Sinahala font

[lahiru.vithanage]

php walin mysql database ekata sinhala content ekak type karala ayema eka web page eke print karaddi eka print wenne na.. but a content ekama nknma html tag ekak athule type karama display wenawa hriyata(databse ekata danne nathuwa nknma html walin).. meka hadaganne khomada???

please help

 

[chathuranga8887]

http://stackoverflow.com/questions/...characters-into-mysql-database-shows-in-field

 

[lovesl]

nvarchar db filed data type denta.
font name eka set karanta.podi wadk thiyeene.

 

[kolavari]

Page eke uda charset eka UTF8 denna

database eketh charset eka denna oneda manda

 

[CustomerSupport]

change database charset to utf8mb4, and collation to utf8mb4 _unicode_ci (requires mysql 5.5 at least).

 

[MihiCherub]

change database charset to utf8mb4, and collation to utf8mb4 _unicode_ci (requires mysql 5.5 at least).

5.1 wala puluwan mama karala thiyenne..

 

[MihiCherub]

php walin mysql database ekata sinhala content ekak type karala ayema eka web page eke print karaddi eka print wenne na.. but a content ekama nknma html tag ekak athule type karama display wenawa hriyata(databse ekata danne nathuwa nknma html walin).. meka hadaganne khomada???

please help

charset eka utf 8 danna. database collation utf8_unicode_ci danna.

ewagema danata utf8 noda gatta backup thiyenawa nam ewa immediately delete karanna. e backup wala sinhala letters mix wela thiyenne. waradilawath e backup eka ayith restore karanna epa. aiyoo data wenawa..
mata ehema una eka parak.

 

[lahiru.vithanage]

thanks okkotama

 

[CustomerSupport]

5.1 wala puluwan mama karala thiyenne..

utf8mb4 awe 5.5.3 wala ban (emoji and all that crap).
< 5.5.3 wala 3-byte utf8 witharai support karanne.

 

[lahiru.vithanage]

eth wada karanne naneeee.. database eken retreive wena eka wada nane.... database eke athule sinhala font eken penawaa.. bt retreive karama wada nane

 

[Hambantota Malli]

utf8mb4 awe 5.5.3 wala ban (emoji and all that crap).
< 5.5.3 wala 3-byte utf8 witharai support karanne.

sinhala unicode වැඩ කරන්න utf8 හොදටම ඇති. unicode emoji ඕනනම් සහ වඩාත් හොද unicode support එකකට utf8mb4 හොදයි.

 

[Hambantota Malli]

eth wada karanne naneeee.. database eken retreive wena eka wada nane.... database eke athule sinhala font eken penawaa.. bt retreive karama wada nane

යකෝ ut8 මෙටා ටැග් එක තියෙන බලපන් Head සෙක්ෂන් එකේ. අනිත් එක ඩේටබේස් එකෙන් ඩේට පුල් කරනකොට php වලින්ම charset එක utf8 වලට සෙට් කරන්න ඕන.

 

[Hambantota Malli]

db connection එක සෙට් කරාට පස්සේ ඒකේ charset එක සෙට් කරපිය.

mysql_set_charset('utf8', $connection);

 

[lahiru.vithanage]

wada wadaa....

 

[Hambantota Malli]

wada wadaa....

මොකෝ වෙලා තිබ්බේ?

 

[lahiru.vithanage]

mn php eken nemei data insert eke.. kelinma database ekenma insert kara kara baluwe.. php walin database ekata insert karala aye retreive karama wada.....