AW: Database utf8 and latin1 questions

2017-01-19 Thread Gregor.Panek
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 Gregor, be carefu

AW: Database utf8 and latin1 questions

2017-01-18 Thread Gregor.Panek
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 this

AW: Database utf8 and latin1 questions

2017-01-18 Thread Frank Zunderer
Januar 2017 15:57 An: dev-general@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

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

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.

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