utf-8 characters become ????????????

[costis]

Hello all!
How could we make the greek utf-8 characters, being entered by a customer, no to get converted to question marks ??

We use mysql with UTF-8 and ci_general collation.

Please help!!!!!!! 

[pete]

Hi,

Can you be a bit more specific about where this is happening ? Can you reproduce it on our online demo ?

Thx,

Pete

[costis]

Thanks for your so quick response!!!
Here is the same situation on your demo. The question marks were once Greek letters before
saving to the database.....

If you could think of a solution there we would be very grateful!

Greetings
Costis (or better Κωστής)

[costis]

You email arrived! Looks like this......
Is 7bit OK?

[pete]

I've just tried it with a database set up for UTF-8 and it works. See attached image:

[costis]

Wow! The fact is that it used to work for me too, but stopped suddenly and since then i keep getting
question marks. We use utf8 everywhere....
Did you use phpMyAdmin for your database settings?

[costis]

The konakart demo, keeps giving me question marks though..... 

[pete]

Yes, the database for the online demo isn't setup correctly to store Greek characters.

[pete]

My database seems to be setup in a similar fashion. If it used to work and suddenly stopped, you should try to figure out what you changed .

[costis]

Thanx for all the support! One question more:

Do you have the URIEncoding="UTF-8" entry like here in your server.xml ?

<!-- Define a non-SSL HTTP/1.1 Connector on port 8080 -->
   <Connector port="8080" maxHttpHeaderSize="8192"
               maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
               enableLookups="false" redirectPort="8443" acceptCount="100"
               connectionTimeout="20000" disableUploadTimeout="true"
               URIEncoding="UTF-8"
   />

[costis]

 URIEncoding="UTF-8" does not do the trick either..... 

[costis]

but then again on my system Verrueckt nach Mary comes with a Question Mark,
while on konakart-demo site it is OK.........

Help needed!

[pete]

My system works after a standard KonaKart install using our installer. From what you said, it looks like your system used to work when you first installed it. My advice is to go through a fresh install process and try again. Are you running on Windows or Linux ?

[costis]

Hi Pete!
We do use both SUSE and Win-XP-SP2. SUSE will be our final target.
We face this problem on both OS's. We have only one correct working shop
right now, and this is on a Win system.

When we write greek into the customers table, with phpMyAdmin, and load the customer's data
to either konakartadmin or konakart, the Greek utf8 letters appear on screen, but as soon as we
edit the data and save they turn to question marks..... King Midas must have had a similar feeling....

[pete]

Since you have one working shop maybe you can spot what is different between the working one and the one that doesn't work ? There should be some clues there.