I have a Access data base wich have both Sinhala(not unicode) and English records.
I converted it to mysql using a access to mysql software and wrote a php code to get data from mysql.
but it out puts crazy symbols with some sinhala words. i can't understand the bug. pls help me.
[ Post made via Mobile Device ]
Sinhala with php and mysql
Re: Sinhala with php and mysql
It seems there is a serious bug in the converter.
1. Try changing the field property of Access DB to Unicode (If the field type is TEXT).
2. Try changing the field type of Access DB to BLOB (If it is TEXT now).
3. You may try with a different one.
4. If you have the source code for the converter then you would also try to fix it for you.
1. Try changing the field property of Access DB to Unicode (If the field type is TEXT).
2. Try changing the field type of Access DB to BLOB (If it is TEXT now).
3. You may try with a different one.
4. If you have the source code for the converter then you would also try to fix it for you.
Re: Sinhala with php and mysql
Thankz,
it worked, but not at all.
what is BLOD?
[ Post made via Mobile Device ]
it worked, but not at all.
what is BLOD?
[ Post made via Mobile Device ]
Re: Sinhala with php and mysql
longer versions of varchars, inside phpmyadmin or mysql you can change the type of field from varchar to blob i think if i remember, i remember messing with it for storing images or files