database character set

Jaromír Talíř jaromir.talir at nic.cz
Mon Jan 5 10:06:20 CET 2009


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 at lists.nic.cz
> https://lists.nic.cz/mailman/listinfo/fred-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 3870 bytes
Desc: not available
Url : http://lists.nic.cz/pipermail/fred-users/attachments/20090105/f15b666e/attachment.bin 


More information about the Fred-users mailing list