Re: Problem with utf-8/Serbian(Latin) [message #1277 is a reply to message #1276] |
Tue, 04 March 2008 06:36 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to previous message](/theme/default/images/down.png) |
AJM
Messages: 2361 Registered: April 2006 Location: Surrey, UK
|
Senior Member |
|
|
This is very strange. I have tried it on my development PC using the XAMPLE subsystem to create a new 'option' record with an id of 'serbian' and a description of 'šđžčćŠĐŽČĆ'. After creating the record it returns to the list screen without a problem, and I can page back and forth through the entries without any problems.
However, when I log on to Radicore and try to do the same thing with the demonstration system I see the behaviour which you describe. I am using the same versions of PHP and MySQL, so something else which is different between the two installations must be causing this error. The only differences are:
- my PC is running Windows XP without the Zend Accelerator
- the Radicore site is running linux with the Zend Accelerator
I will have to investigate further to find out what is causing this, but without the ability to duplicate this error on my development PC it is going to be difficult.
FYI my method of dealing with all the different languages is to use the UTF8 character set throughout:
- I set default_charset to 'UTF-8' in the htaccess file.
- after connecting to the database I use the query "SET names 'UTF8'" to define the character set for the connection.
- all databases, tables and columns have the collation set to 'utf8_unicode_ci'.
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|