Database utf8 and latin1 questions

2017-01-18 Thread Gregor.Panek
Hi all, I'm currently changing our database to utf-8 with the provided OXID script from this page: https://www.oxid-esales.com/en/support-services/documentation-and-help/oxid-eshop/installation/oxid-eshop-update-installation/update-eshop-to-utf-8-encoding.html Now I'm still wondering why we chan

Re: Database utf8 and latin1 questions

2017-01-18 Thread Gregor Hyneck
Hi Gregor only the columns which are supposed to have utf8 content are changed. We saw no benefit to do this for the id columns. If we would change the id columns, there could be problems with 3rd party systems or more effort to update an existing database. But you are right, this behavior is

Re: Database utf8 and latin1 questions

2017-01-18 Thread Tomas Kvietkauskas
Hello, I think this is more related to memory size, latin is a single byte encoding while utf8 is two byte encoding (any sysadmin/db admin there correct me if I am wrong?) The other thing that you should keep all ids the same latin encoding to prevent type conversion on mysql queries/joins. -

AW: Database utf8 and latin1 questions

2017-01-18 Thread Gregor.Panek
Re: Database utf8 and latin1 questions Hello, I think this is more related to memory size, latin is a single byte encoding while utf8 is two byte encoding (any sysadmin/db admin there correct me if I am wrong?) The other thing that you should keep all ids the same latin encoding to prevent typ

AW: Database utf8 and latin1 questions

2017-01-18 Thread Frank Zunderer
@lists.oxidforge.org Betreff: AW: Database utf8 and latin1 questions Hi both of you, thanks for the information and explanation. Now I understand your thoughts about the migration to utf8. It's fine for me just wanted some background information J Best regards Gregor Panek Softwareentwi

AW: Database utf8 and latin1 questions

2017-01-18 Thread Gregor.Panek
switch to utf8. Best regards Gregor Von: Frank Zunderer [mailto:frank.zunde...@zunderer.de] Gesendet: Mittwoch, 18. Januar 2017 17:01 An: dev-general@lists.oxidforge.org<mailto:dev-general@lists.oxidforge.org> Betreff: AW: Database utf8 and latin1 questions Hi Gregor, be careful when using

AW: Database utf8 and latin1 questions

2017-01-19 Thread Gregor.Panek
not the only one who wants to switch to utf8. Best regards Gregor Von: Frank Zunderer [mailto:frank.zunde...@zunderer.de] Gesendet: Mittwoch, 18. Januar 2017 17:01 An: dev-general@lists.oxidforge.org<mailto:dev-general@lists.oxidforge.org> Betreff: AW: Database utf8 and latin1 questions Hi