Sinhala with php and mysql

Post Reply
User avatar
Rksk
Major
Major
Posts: 730
Joined: Thu Jan 07, 2010 4:19 pm
Location: Rathnapura, Sri Lanka

Sinhala with php and mysql

Post by Rksk » Sun Aug 29, 2010 11:01 pm

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
User avatar
Neo
Site Admin
Site Admin
Posts: 2642
Joined: Wed Jul 15, 2009 2:07 am
Location: Colombo

Re: Sinhala with php and mysql

Post by Neo » Mon Aug 30, 2010 11:00 am

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.
User avatar
Rksk
Major
Major
Posts: 730
Joined: Thu Jan 07, 2010 4:19 pm
Location: Rathnapura, Sri Lanka

Re: Sinhala with php and mysql

Post by Rksk » Mon Aug 30, 2010 2:04 pm

Thankz,
it worked, but not at all.

what is BLOD?

[ Post made via Mobile Device ] Image
Mysoogal
Captain
Captain
Posts: 223
Joined: Thu Dec 17, 2009 7:15 am
Location: Planet VPS

Re: Sinhala with php and mysql

Post by Mysoogal » Tue Aug 31, 2010 1:52 am

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
Post Reply

Return to “PHP & MySQL”