problem with french accents

[luctrudel]

Using remote list with accents, I have a problem with lists that have accents as they appear with little squares in lieu of accents.

I'm dealing with many names with accents so it is annoying.

What should be my encoding settings?

Thanks

 

[stanbusk]

How did you create those entries? Thru MLM subscribes? I have no problems here with accents. I can also use Japanese and Russian.

 

[luctrudel]

maxbulk mailer accents

Hello Stan,

Whenever I import my lists in maxbulk mailer I see those accents.

I have tried changing them in mbm and then uploading the changes but the problem persists.

LT

 

[stanbusk]

Yes but how did you create those entries? Thru MLM subscribes?

 

[luctrudel]

Not necessarily.

Why does it matter?

LT

 

[stanbusk]

How are your lists created? Could you give me more information?

 

[luctrudel]

They are old lists. I don't know exactly how they were created. Some entries are the newer ones entered with the mlm subscribe feature.

Is there a process I can do to my list to have all the encoding reset?

 

[stanbusk]

Difficult to know with so few information. The encoding of a string is the one used when you write the string. Then you have to make sure to use the same one when reading. Both MLM an MaxBulk Mailer uses unicode UTF-8 for both reading and writing.

In MLM, are you using the mySQL option?

 

[luctrudel]

yes

 

[stanbusk]

Ok. If you are using mySQL you can look at the records directly to see if they show accentuated characters or not. Most hosting control panels include phpmyadmin or similar, a system that lets you browse and edit mySQL tables.

 

[luctrudel]

when I checked they showed weird characters, not my accents.

 

[stanbusk]

Where, in mySQL?

 

[luctrudel]

yes in phpadmin

 

[stanbusk]

What happens if you edit the entry and save it? Have you tried to subscribe yourself to see what happens with accents?

By the way, I guess you are using current MaxBulk Mailer v6.7, right?

 

[luctrudel]

When I subscribed with mlm subscribe form the accents were good.

When I upload a file the accents go wrong.


LT

 

[stanbusk]

Yes but what happens if you edit the entry and save it? I mean with phpmyadmin? Are you sure your mySQL version supports unicode?

 

[luctrudel]

When I change an entry in phpadmin it does the change there, and shows the correct accents; However when I save it doesn't seem to save because when I go back in mailer to check my list the change wasn't made.

Basically, from what I know when I upload a file to my list that's where it goes wrong.

So I will find out more about the myspl that I'm using by calling my server host people.

 

[luctrudel]

Hello Stan,
these are the variables in my mysql - phpadmin

character_set_client latin1
character_set_connection latin1
character_set_database utf8
character_set_filesystem binary
character_set_results latin1
character_set_server latin1
character_set_system utf8
character_sets_dir /usr/local/nf/mysql-5.0/share/mysql/charsets/
collation_connection latin1_swedish_ci
collation_database ut8_general_ci
collation_server latin1_swedish_ci

 

[stanbusk]

Try to convert the file to upload to UTF-8. You can do that with free TextWrangler.

 

[luctrudel]

textwrangler is for mac. I have a pc. I will look for something else to do the same thing on pc.