Petur Kirke píše v Ne 04. 01. 2009 v 17:07 +0000:
Hello
I can see that the FRED database (PostgreSQL) is in UTF-8.
Since i am using PHP, and i got some problems with UTF-8, I am considering to change the
PostgreSQL database to ISO 8859-1 character set.
question 1)
Is it safe to do this ?
Is there anything i should reconsider before doing this ?
Hello Petur,
I have never tried any other encoding than UTF8 and I think there could
be some complications. First, I guess, mod_eppd module which does xml
parsing transfer internally data to UTF8 because input xml can be in any
possible encoding. But if you are writing just client application you
can send xml in 8859-1. You will probably recieve xml in UTF8 but any
compliant xml parsing library should handle this. You don't need to care
what encoding database has.
question 2)
And how can i set the character set, if i use the commands below ?:
fred-dbmanager uninstall
fred-dbmanager install
Database encoding is hardcoded in fred-dbmanager shell script in call to
'createdb' command. You can change it, but I would rather recommend to
change encoding on input and output of FRED to UTF8.
Petur
This email and its attachments may be confidential and are intended solely for the use of
the individual to whom it is addressed.
If you are not the intended recipient or authorized to receive information for the
intended recipient you are notified that disclosing, copying, distributing or taking any
action in reliance on the contents of this information is strictly prohibited. If the
email contains proposals, they are valid for 30 days following the date of email
transmission. Finally, the recipient should check this email and any attachment for the
presence of viruses. The company accepts no liability for any damage caused by any virus
transmitted by email.
_______________________________________________
Fred-users mailing list
Fred-users(a)lists.nic.cz
https://lists.nic.cz/mailman/listinfo/fred-users