- Posts: 7
- Home
- Forum
- Community Forum
- Questions
- Installation/Upgrade
- Orient Template
Category and room description UTF-8 problem
- illumcsilla
- Topic Author
- Offline
Less
More
8 years 7 months ago - 8 years 7 months ago #6211
by illumcsilla
Category and room description UTF-8 problem was created by illumcsilla
Hy,
After save element character ő and ű transform to ? character
A minibár és hűtőszekrény is biztosított.
A minibár és h?t?szekrény is biztosított.
And not only descrition but also all imput text same problem!
This really must be solved in this way?
latin1_swedish_ci change to utf8_general_ci
atached photo..
Is there any solution to it is normal that you do not have to manually reconfigure each imput field?
ex.:
After save element character ő and ű transform to ? character
A minibár és hűtőszekrény is biztosított.
A minibár és h?t?szekrény is biztosított.
And not only descrition but also all imput text same problem!
This really must be solved in this way?
latin1_swedish_ci change to utf8_general_ci
atached photo..
Is there any solution to it is normal that you do not have to manually reconfigure each imput field?
ex.:
ALTER TABLE `jos_sr_config_data` CONVERT TO CHARACTER SET utf8;
Last edit: 8 years 7 months ago by illumcsilla.
Please Log in or Create an account to join the conversation.
- vietvh
-
- Offline
Less
More
- Posts: 1553
8 years 7 months ago #6214
by vietvh
Replied by vietvh on topic Category and room description UTF-8 problem
Hi,
Nice week to you.
If your database was created with UTF8 as default collation, then all tables added later will use it. In your case, look like your database does not use UTF8 as default, instead it is using Latin, that's why some tables and fields are using it.
AFAIK, you need to change it back to UTF8 manually because there is no simple way to change it automatically for all fields.
Regards,
Nice week to you.
If your database was created with UTF8 as default collation, then all tables added later will use it. In your case, look like your database does not use UTF8 as default, instead it is using Latin, that's why some tables and fields are using it.
AFAIK, you need to change it back to UTF8 manually because there is no simple way to change it automatically for all fields.
Regards,
Please Log in or Create an account to join the conversation.
- illumcsilla
- Topic Author
- Offline
Less
More
- Posts: 7
8 years 7 months ago - 8 years 7 months ago #6219
by illumcsilla
Replied by illumcsilla on topic Category and room description UTF-8 problem
Dear vietvh,
In my test run this:
Result is:
It appears the system works and letters with accents appear correctly
xxx table prefix because is secret ...
Do you think this conversion problem will cause the environment is functioning?
Atached photo after convert result
In my test run this:
ALTER TABLE `yourprefix_sr_config_data` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_countries` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_coupons` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_currencies` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_customers` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_customer_fields` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_customer_groups` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_extras` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_geo_states` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_media` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_media_reservation_assets_xref` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_media_roomtype_xref` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_reservations` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_reservation_assets` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_reservation_asset_fields` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_reservation_extra_xref` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_reservation_notes` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_reservation_room_details` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_reservation_room_extra_xref` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_reservation_room_xref` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_rooms` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_room_types` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_room_type_coupon_xref` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_room_type_extra_xref` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_room_type_fields` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_tariffs` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_tariff_details` CONVERT TO CHARACTER SET utf8;
ALTER TABLE `yourprefix_sr_taxes` CONVERT TO CHARACTER SET utf8;Result is:
ALTER TABLE `xxx_sr_config_data` CONVERT TO CHARACTER SET utf8;# 250 line concerned.
ALTER TABLE `xxx_sr_countries` CONVERT TO CHARACTER SET utf8;# 245 line concerned.
ALTER TABLE `xxx_sr_coupons` CONVERT TO CHARACTER SET utf8;# 8 line concerned.
ALTER TABLE `xxx_sr_currencies` CONVERT TO CHARACTER SET utf8;# 4 line concerned.
ALTER TABLE `xxx_sr_customers` CONVERT TO CHARACTER SET utf8;# 5 line concerned.
ALTER TABLE `xxx_sr_customer_fields` CONVERT TO CHARACTER SET utf8;# MySQL returned an empty result set (ie. Zero rows).
ALTER TABLE `xxx_sr_customer_groups` CONVERT TO CHARACTER SET utf8;# 5 line concerned.
ALTER TABLE `xxx_sr_extras` CONVERT TO CHARACTER SET utf8;# 10 line concerned.
ALTER TABLE `xxx_sr_geo_states` CONVERT TO CHARACTER SET utf8;# 521 line concerned.
ALTER TABLE `xxx_sr_media` CONVERT TO CHARACTER SET utf8;# 58 line concerned.
ALTER TABLE `xxx_sr_media_reservation_assets_xref` CONVERT TO CHARACTER SET utf8;# 50 line concerned.
ALTER TABLE `xxx_sr_media_roomtype_xref` CONVERT TO CHARACTER SET utf8;# 75 line concerned.
ALTER TABLE `xxx_sr_reservations` CONVERT TO CHARACTER SET utf8;# 40 line concerned.
ALTER TABLE `xxx_sr_reservation_assets` CONVERT TO CHARACTER SET utf8;# 6 line concerned.
ALTER TABLE `xxx_sr_reservation_asset_fields` CONVERT TO CHARACTER SET utf8;# 198 line concerned.
ALTER TABLE `xxx_sr_reservation_extra_xref` CONVERT TO CHARACTER SET utf8;# 2 line concerned.
ALTER TABLE `xxx_sr_reservation_notes` CONVERT TO CHARACTER SET utf8;# MySQL returned an empty result set (ie. Zero rows).
ALTER TABLE `xxx_sr_reservation_room_details` CONVERT TO CHARACTER SET utf8;# 24 line concerned.
ALTER TABLE `xxx_sr_reservation_room_extra_xref` CONVERT TO CHARACTER SET utf8;# 70 line concerned.
ALTER TABLE `xxx_sr_reservation_room_xref` CONVERT TO CHARACTER SET utf8;# 52 line concerned.
ALTER TABLE `xxx_sr_rooms` CONVERT TO CHARACTER SET utf8;# 68 line concerned.
ALTER TABLE `xxx_sr_room_types` CONVERT TO CHARACTER SET utf8;# 15 line concerned.
ALTER TABLE `xxx_sr_room_type_coupon_xref` CONVERT TO CHARACTER SET utf8;# 24 line concerned.
ALTER TABLE `xxx_sr_room_type_extra_xref` CONVERT TO CHARACTER SET utf8;# 22 line concerned.
ALTER TABLE `xxx_sr_room_type_fields` CONVERT TO CHARACTER SET utf8;# 103 line concerned.
ALTER TABLE `xxx_sr_tariffs` CONVERT TO CHARACTER SET utf8;# 45 line concerned.
ALTER TABLE `xxx_sr_tariff_details` CONVERT TO CHARACTER SET utf8;# 462 line concerned.
ALTER TABLE `xxx_sr_taxes` CONVERT TO CHARACTER SET utf8;# 4 line concerned.It appears the system works and letters with accents appear correctly
xxx table prefix because is secret ...
Do you think this conversion problem will cause the environment is functioning?
Atached photo after convert result
Last edit: 8 years 7 months ago by illumcsilla.
Please Log in or Create an account to join the conversation.
- vietvh
-
- Offline
Less
More
- Posts: 1553
8 years 7 months ago #6221
by vietvh
Replied by vietvh on topic Category and room description UTF-8 problem
Hi,
From your result list, I don't see any issues with it, so I believe you are good to go. If you have any issues just let us know.
Regards,
From your result list, I don't see any issues with it, so I believe you are good to go. If you have any issues just let us know.
Regards,
Please Log in or Create an account to join the conversation.
Moderators: solidres