4 Led
2009
4 Led
'09
18:07
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 ?
question 2)
And how can i set the character set, if i use the commands below ?:
fred-dbmanager uninstall
fred-dbmanager install
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.
5 Led
5 Led
10:06
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
10:59
New subject: SV: database character set
thanks for the answer.
One more question:
When i use the fred-client commands such as "create_domain" and
"create_contact", the input to the database is always (automatically) UTF-8,
even if it is done through PHP pages, which are ISO 8859-1 ? is this right ? do you know
?
________________________________________
Fra: fred-users-bounces(a)lists.nic.cz [fred-users-bounces(a)lists.nic.cz] På vegne
af Jaromír Talíř [jaromir.talir(a)nic.cz]
Sendt: 5. januar 2009 09:06
Til: fred-users(a)lists.nic.cz
Emne: Re: database character set
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
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.
11:07
New subject: SV: database character set
This is correct. As I wrote before, there is translation into UTF8
during XML parsing in mod_eppd.
Jaromir
Petur Kirke píše v Po 05. 01. 2009 v 09:59 +0000:
thanks for the answer.
One more question:
When i use the fred-client commands such as "create_domain" and
"create_contact", the input to the database is always (automatically) UTF-8,
even if it is done through PHP pages, which are ISO 8859-1 ? is this right ? do you know
?
________________________________________
Fra: fred-users-bounces(a)lists.nic.cz [fred-users-bounces(a)lists.nic.cz] På vegne
af Jaromír Talíř [jaromir.talir(a)nic.cz]
Sendt: 5. januar 2009 09:06
Til: fred-users(a)lists.nic.cz
Emne: Re: database character set
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
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
5829
days inactive
5830
days old
3 comments
2 participants
participants (2)
-
Jaromír Talíř -
Petur Kirke