Same here for german special characters like ä, ö, ü, ß, …
Everything was fine some days ago.
Another buggy thing beside the “?” in the sql results is that I get an error when there is a special character in the column name:
#1. [abase sql="SELECT Straße FROM [...]"]
Fatal Error (1431)
Unknown column 'Straße' in 'field list'
You are using the sql="" attribute so make sure it contains a valid SQL statement. Check to make sure the spelling of all table or column names within the SQL statement are exactly correct.
Oh God, look down from heaven. What am I to do?
Update:
This still works fine:
[abase columns="Straße" ...]
but this newly doesn’t:
[abase sql="SELECT Straße ...]
this solutions work for me:
enable special characters in field value:
<div style="visibility: hidden">[abase sql="SET @@session.character_set_results=utf8"]</div>
enable special characters in column names:
<div style="visibility: hidden">[abase sql="SET @@session.character_set_client=utf8"]</div>
Thread Starter
svenar
(@svenar)
Hi wordsuppressor!
I don’t know who you are, but your solution worked for me also :)!!!
THANK YOU VERY MUCH!!!
Hi,
“…@@session.character_set_results=utf8…” was not solution in my case, maybe is PHP version…
I forced manually the PHP connection. After line 618 in abase.php
$abase_conn = mysql_connect($sqlHost, $sqlUser, $sqlPass) …
//Add force utf-8 connection
mysql_set_charset(‘utf8’,$abase_conn);
I hope this usefull to someone.
