Hi,
I have some VARCHAR fields whose character set were incorrectly
defined as NONE. I would like to use ISO8859_1 instead.
I read on "The Firebird Book" that in order to do so you must add a
new temporary field, with the right character set, fill it with the data
from the original field ( using OCTECT as an intermediat chararacter set
) and finally drop and recreate the original field with the right
character set, filling it with the data that was stored in the temporary
field. The process ends up dropping the temporary field.
I wonder what is wrong with simply invoking "ALTER TABLE X ALTER
COLUMN Y TYPE CHAR(N) CHARACTER SET ISO8859_1"
Thanks in advance for any help.
Aldo Caruso
------------------------------------
------------------------------------
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------
Yahoo Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-dig...@yahoogroups.com
firebird-support-fullfeatu...@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/
