This content has been marked as final. Show 1 reply
I suppose characterset conversion doesn't occur.I suppose it does occur, otherwhise the strings would use the same amount of bytes. Note that in AL32UTF8, some (special) characters use more than one byte, so you might need more space to store the same value. Of course, you gain the advantage to be able to store (nearly) any special character of (nearly) any charset.
So, if you want to avoid that problem, don't define your columns with byte length (which is default) but with CHAR-length, e.g.
That way, you'll always be able to store 30 characters with respect to the needs of your charset.
DESCRIPTION NOT NULL CHAR(30 CHAR)