Subject | Is it possible to change the charset of all column ? |
---|---|
Author | nathanelrick |
Post date | 2012-02-06T07:27:04Z |
Hello,
Is it possible to change the charset of all columns and also the default database charset to NONE? i just want to change the charset definition, not the data himself. This because i want that it is the client to be responsible to know in with charset he store the data.
i know their is some tools to make a backup of the database in SQL script and after we can edit this script (like in mysql), but our database is too big for such script (+300 GO) and the backup / restore will take weeks :(
Is it possible to change the charset of all columns and also the default database charset to NONE? i just want to change the charset definition, not the data himself. This because i want that it is the client to be responsible to know in with charset he store the data.
i know their is some tools to make a backup of the database in SQL script and after we can edit this script (like in mysql), but our database is too big for such script (+300 GO) and the backup / restore will take weeks :(