Page 1 of 1

Sinhala with php and mysql

Posted: Sun Aug 29, 2010 11:01 pm
by Rksk
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 ] Image

Re: Sinhala with php and mysql

Posted: Mon Aug 30, 2010 11:00 am
by Neo
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.

Re: Sinhala with php and mysql

Posted: Mon Aug 30, 2010 2:04 pm
by Rksk
Thankz,
it worked, but not at all.

what is BLOD?

[ Post made via Mobile Device ] Image

Re: Sinhala with php and mysql

Posted: Tue Aug 31, 2010 1:52 am
by Mysoogal
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 :D