Page 1 of 1

problems with umlaut/mutated vowel

Posted: Sat May 05, 2012 9:46 pm
by dennis
Hi again

i just imported a backup made with phpMySQLAutoBackup and noticed that there are problems with the german umlaut(s) ä,ü,ö and probably the sharp ß.

discussion titles are cut of at the point where one of thos characters appear, words in general that have one of those mutated vowels in it are cut off now after the import
in the dumped SQL files it replaces the

Code: Select all

ö
with a

Code: Select all

^
and the

Code: Select all

ü
with a

Code: Select all

¸
, the

Code: Select all

ä
with a

Code: Select all



i don't know, maybe this happens to all special characters?
is there a fix for this?

would be great, because i really like this script

Re: problems with umlaut/mutated vowel

Posted: Sun May 06, 2012 6:56 am
by davidgwalker
Dennis, it could be related to the encoding used, please see:
viewtopic.php?f=2&t=1013&p=4412&hilit=utf#p4412

If it corrects the issue please post your positive results; or if you find another solution please post details. I can not offer any further help.

Thanks

Dave

Re: problems with umlaut/mutated vowel

Posted: Sun May 06, 2012 5:55 pm
by dennis
thanks. which file do o add the lines to? i couldn't find the mysql_connect() statement.

Re: problems with umlaut/mutated vowel

Posted: Sun May 06, 2012 6:28 pm
by davidgwalker
davidgwalker wrote:...I can not offer any further help.
without payment, sorry.

Re: problems with umlaut/mutated vowel

Posted: Sun May 06, 2012 6:31 pm
by dennis
what do you mean, whithout payment?
i just need to know where to add these lines, which file...

mysql_query("SET session character_set_results = 'UTF8'");
mysql_query("SET session character_set_client = 'UTF8'");
mysql_query("SET session character_set_connection = 'UTF8'");
mysql_query("SET session character_set_results = 'UTF8'");
mysql_query("SET session character_set_server = 'UTF8'");

i'm confused about your response

Re: problems with umlaut/mutated vowel

Posted: Mon May 07, 2012 2:20 pm
by dennis
well, i guess I have to look for an alternative script then.

i honestly don't get why you wouldn't just help me out.
i don't know what kind of payment you're asking, but obviously you wouldn't get rich from it.
too bad, really.

Re: problems with umlaut/mutated vowel

Posted: Mon May 07, 2012 5:38 pm
by dennis
at least now after you deleted my previous post i know that you read my other posts. good luck for the future. you seem to need it