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
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
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
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
@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
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
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