Subject | Changing default character set |
---|---|
Author | Peter Chaisty |
Post date | 2006-05-18T17:12:20Z |
Hi
I have an existing database which works fine in countries I have used
thus far, it uses defualt char set none.
Greece has now moved into the mix and after evaluating the various
options I have decided to use the iso8859-2 character set as the
default one for the greek version of the db.
I store all kinds of greek text and receipt layouts in text blob fields.
My question is
Is there a way to change the default character set say using gbak , I
was convinced I had seen this somewhere but I am unable to find it
thus far.
Alternatively is there a easier way other than extracting the ddl,
recreating the db and pumping the existing data over .
Any suggestions / advice gratefully received.
Peter
I have an existing database which works fine in countries I have used
thus far, it uses defualt char set none.
Greece has now moved into the mix and after evaluating the various
options I have decided to use the iso8859-2 character set as the
default one for the greek version of the db.
I store all kinds of greek text and receipt layouts in text blob fields.
My question is
Is there a way to change the default character set say using gbak , I
was convinced I had seen this somewhere but I am unable to find it
thus far.
Alternatively is there a easier way other than extracting the ddl,
recreating the db and pumping the existing data over .
Any suggestions / advice gratefully received.
Peter