Subject | Charsets |
---|---|
Author | Aldo Caruso |
Post date | 2014-09-26T13:44:59Z |
Hello,
Given a populated database with default character set = None.
Some fields have character set = None while others have character
set = ISO8859_1
1) Which is the best way to modify those field definitions which
have character set = None to character set = ISO8859_1 (there are char,
varchar as well as blob type text fields) without losing information ?
2) Can the default character set be changed ? In that case, does it
affect current fields that have character set = None or it only affects
the character set of future fields definitions ?
Thanks in advance,
Aldo
Given a populated database with default character set = None.
Some fields have character set = None while others have character
set = ISO8859_1
1) Which is the best way to modify those field definitions which
have character set = None to character set = ISO8859_1 (there are char,
varchar as well as blob type text fields) without losing information ?
2) Can the default character set be changed ? In that case, does it
affect current fields that have character set = None or it only affects
the character set of future fields definitions ?
Thanks in advance,
Aldo