Битрикс для разработчиков
Чат экстремального погром...
Qt
symfony
Ansible
Unity Engine: вопрос - от...
Nuxt.js | Vue SSR
Боты на Telegraf
Data Science Chat
Android Architecture
QA — русскоговорящее сооб...
DBA - русскоговорящее соо...
Tarantool
Unreal Engine
☁️ AWS_RU
Blender_ru: вопрос-ответ.
MongoDB Russian
Yandex Cloud - Официальны...
Git
DevsHelper
Big Data Science :: AI / ...
pro.kafka
3ds Max
1C
Вокруг да около Zigbee
Android Declarative
freebsd_ru
Atlassian Community - Rus...
ru_mysql
Чат про Fusion 360 и 3D
OctoberCMS
ru_gitlab
Godot Engine (Russian)
MySQL
Yii Framework 2
Data Engineers
Чат Tableau
Cinema 4D
Evolution CMS
Odoo talks & fun
Software Design/Architect...
pro.buildsystems
Webpack — русскоговорящее...
Yii Framework 3
QA juniors
RUSCADASEC community: Киб...
ru_hashicorp
Grafana Loki
VictoriaMetrics_ru
.NET Group
Google Cloud Platform_ru
DevSecOps - русскоговорящ...
![Netbeans [RU]](https://image.telq.org/channel_avatar_1102508152_467588515831589735_mini.jpeg){kind=avatar}
Netbeans [RU]
Hi guys, I have a problem with converting my table
from utf8 + utf8_general_ci to utf8mb4 + utfmb4_unicode_ci to support smilies to save in my database(MySQL 5.6). I confused because i have data more than VARACHAR(191) and when I converting to utf8mb4 I got Data truncation error. I using InnoDB engine and must to short my VARCHAR(255) to VARCHAR(191) ( 4-byte character encoding in utf8mb4). Does anyone have an idea?
8 ответов
This is Russian chat, if you want to read and write in English, go to the English chat, the link is in the description of this chat
This is because size of varchar is in bytes but smilies and many other Unicode characters can take 4 and sometimes up to 6 bytes. You have to expand your field.
Sasha
Автор вопроса
This is because size of varchar is in bytes but sm...
Ty for your answer. I basically do not speak Russian but I can read or I can write in Ukrainian if you want
Sasha
Автор вопроса
This is because size of varchar is in bytes but sm...
I can't do this because my fields is indexed before by InnoDB
I can't do this because my fields is indexed befor...
Ну это попровимо. Удаляешь индекс, меняешь размер поля, создаёшь индекс назад
I can't do this because my fields is indexed befor...
При смене коллейшена всё равно надо пересоздавать индекс. Так что странно что это может мешать
Sasha
Автор вопроса
Ну это попровимо. Удаляешь индекс, меняешь размер ...
I don't know if this will do much damage to my database, I have 10 fields to change and a lot of available data. I'm not very strong in MySQL so I'm asking the guru
Ty for your answer. I basically do not speak Russi...
Тут в чате много украинцев, не менжуйся, пиши по-украински 😂
Похожие вопросы
Обсуждают сегодня