Character BUG - Unicode? (General)
I think it is better to start a new thread - the last UTF-8 thread is a little bit confusing.
Today I have tried several things to solve my problems with the german special characters.
I set up a complete new vhost on my server and added a new postgre user to be exclude all possible things.
So I first tried to install 2.6.27 - everything was working like a charme. Dataset creation with Austrian-chart.sql worked well and saving and retreiving the german special characters worked as it is supposed to do.
Next I removed all files, dropped the database and started with 3.0.5 - some interesting things happened:
I had to iconv the Austrian-chart.sql from ISO-8859-1 to UTF-8 to get the sql to database - it did not matter whether to put "AddDefaultCharset On" in my vhost configuration. Also importing this file via command line gave me errors:
"ERROR: invalid byte sequence for encoding "UTF8": 0xfc" is only one of them.
BUT: importing my iconved sql works like it is supposed to do
AND: SQL Ledger is working - but I have to use "German (ISO-8859-1)" in user preferences to get my data written correct to the database and also receive the correct from my database. I also can change records an my german special characters do not transform to unreadable code.
Next i removed all files once more and tried with 3.2.0 - I also had to iconv my Austrian-chart.sql from ISO-8859-1 to UTF-8 to get it to the database.
BUT then: it does not matter which preferences I use - with "German (ISO-8859-1)" and "AddDefaultCharset On" I'm getting my special charactes stored correctly in my database, but I do only get unreadable code returned when I want to show this data in my web frontend.
With "German (UTF8)" and "AddDefaultCharste On" not even the german special characters in Webfrontend are displayed properly e.g. "Lizensiert für" is display as "Lizensiert fÃ¼r". But I can store my special characters in my database, but do not get them back correctly.
When I add "AddDefaultCharset utf-8" to my vhost configuration and choose "German (UTF-8)" the webfrontend is displayed properly, but my german special characters are not stored correctly in the database and so they are not displayed properly in webfrontend when I search for this records.
I've spend some hours to investigate in this behaviour and was not able to solve my problem - I have to say, our company has focus on MySQL and PHP and some experience with UTF-8 in webprojects - but unfortunately not with Postgres and Perl.
It would be nice if our problem can be solved.
Feel free to ask me if you have further questions regarding our system environment.
Next week I think I will try to install SQL Ledger on another gentoo server to exclude that our server has some buggy configuration. But I have to say, that we don't have any problems on this machine with temporary PHP/MySQL projects in UTF-8
Thanks for reading and trying to help to solve our issue.