Board index » delphi » Changing character set

Changing character set

Hi all,
        can i change default character set for database after its creation, or
must create new?

thanx

 

Re:Changing character set


Quote
> can i change default character set for database after its creation, or
> must create new?

Default character set for database is stored in RDB$DATABASE table,
where you can directly change it.
But is it what you really want ? The default is used only when creating
new objects (tables, procedures ...); it does not affect already existing objects.

--
Ivan
http://www.volny.cz/iprenosil/interbase

Re:Changing character set


I've read here when changing the character set for one field
you should do
update SomeTable set Somefield = SomeField

is this True ?

So if you want to change the character set of the complete database
should you :
- create new empty database and pump all data from one database to another ?
- or would a backup-restore with GBak be enough ?

Other Threads