loading cyrillic leads

[Op3r]

This is going to be a head ache of mine

How do you load leads if it is in cyrillic?

[mflorell]

That sounds very interesting

What is the language set that MySQL was installed with?

What version of MySQL are you using?

[Op3r]

english?

Im using mysql without any problem whatsoever just that a client will load leads in cyrillic

[mflorell]

Not sure what to say, I have heard from other users that have set MySQL to different languages that don't seem to have an issue with it, but that might require some reworking of your database. Maybe switching the language to UTF8 would do the trick since that's supposed to be able to handle everything.

[Op3r]

Oh so its definitely the encoding?

Let me try to switch it to UTF8

thanks man.

[Op3r]

made it to switch to UTF by adding this to my.cnf

# utf8
init-connect='SET NAMES utf8'
character-set-server=utf8
collation-server=utf8_general_ci

now instead of empty spaces I get ??????

do I need something else too? chenge the encoding of the php scripts?

[mflorell]

I have not worked with that myself, but it is possible that you may need to recompile PHP for the same language.

[Op3r]

Im thinking about reformatting the server and do it in russian.

[heinz]

Hi Op3r,

are you still working on that issue?
I have a quite similar problem with special characters like äöü... I changed a lot to utf-8 and even used utf8_encode (PHP) in the code. The result is I get everything displayed fine (at least seems to) but it gets written back into the database totally messed up (i.e. if the agent adds a comment).

If you have any new infos I would be glad to hear them...

Thanks,
heinz

[Op3r]

How did you managed to do that? care to elaborate more?

[heinz]

Hi,

I am still experimenting with admin_modify_lead.php

The best result I got so far was when I changed the code (i.e. around line 320) to something like that:

Code: Select all

$first_name      = utf8_encode($row[13]);

In this case it displays the data fine, but in the db the special-characters appear cryptic. Therefore I still can't export the data from the db without mistakes.
Sometimes the browser or terminal changes the character encoding automatically.
I am so confused...

thanks,
heinz