PDA

View Full Version : Internationalization - Change charset


slfljp
07-04-2008, 06:42 AM
Hi,
First, thank you for developping great software.

Currently working on internationalization of ilance - especially 2bytes character set environment, such as chinese and japanese.

Here's my problem,

1. Post something in the working website - such as " new test project " in 2 bytes character set, then got results below,
#Title - OK (2 bytes character appear)
#Description- NG (got below characters)

&_#_12486;&_#_12473;&_#_12488;
(without underbar _)

#Additional questions - OK (2 bytes character appear)
#Preferred Payment Methods - OK (2 bytes character appear)

2. After post made, "update project" and edit the project, then got results below,
#Title - NG (got below characters)
&_#_12486;&_#_12473;&_#_12488;
(without underbar _)
#Description- OK (2 bytes character appear)
#Questions or additional requirements - OK (2 bytes character appear)
#Keywords / Tags - NG (got below characters)
&_#_12486;&_#_12473;&_#_12488;
(without underbar _)#Preferred Payment Methods - NG (got below characters)
&_#_12486;&_#_12473;&_#_12488;
(without underbar _)

3. Search doesn't work for 2 bytes character

Put 2bytes keyword (it set in post auction before) and get result of
0 listings found with keyword(s): &_#_12486;&_#_12473;&_#_12488;
(without underbar _)

---------------------------------------------

to solve this, one solution is to change character set,I guess.

But can't change whole site to other character set to UTF-8 or something that good for supporting 2bytes characters.

I tried to make new language and let it use UTF-8

Language Administration >Create >Languages
"character set"

but doesn't work....

here's what admin panel gives me

Below is the currently configured character set and connection collation details for your database server useful for debugging.
character_set ujis
character_sets latin1 big5 czech euc_kr gb2312 gbk latin1_de sjis tis620 ujis dec8 dos german1 hp8 koi8_ru latin2 swe7 usa7 cp1251 danish hebrew win1251 estonia hungarian koi8_ukr win1251ukr
greek win1250 croat cp1257 latin5

Could I get some help with this ?
thank you in advance.

wterpilo
07-04-2008, 12:02 PM
Hi
can you PM me with your license key? You're looking as unlicensed user now.

Wojtek

slfljp
07-04-2008, 12:12 PM
Hi,
License key sent through PM

thank you

slfljp
07-04-2008, 12:15 PM
And filled my profile on this forum,
I finally found where to put my license key - in User CP

Peter
07-04-2008, 12:26 PM
The base of your problem seems to be clear:

You need to prepare your database (mysql) collation tables to utf8. As you can see, they are mixed between latin1 and latin2. If you prepare your db before you install ILance using utf8 it should provide more stable results.

Have you tried this yet?

Regards,
Peter