sql - Migrating from Oracle to MySQL. VARCHAR2 length defined using bytes. How to port? -

i have variable in oracle procedure declared this:

mymsg  varchar2(256 byte)

how can port mysql? because when try declare in mysql procedure:

declare mymsg varchar(256 byte);

mysql throws me syntax error.

how can port oracle variable definition mysql?

it 256 byte part doesn't let me declare variable in mysql , need find similar 256 byte expression in mysql.

in mysql, varchar colums declared this

   colname varchar(256),    varchar(20) not null,

etcetera. oracle syntax different.

in stored code in mysql, inside function or procedure scope, variables declared this:

    declare mymsg varchar(256);

if you're not aware of this, be: oracle pl/sql , mysql's little language stored code different each other.

Dil