By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,404 Members | 1,873 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,404 IT Pros & Developers. It's quick & easy.

How to change character encoding of an existing database

P: 36
Hi all,

Can I change the character encoding of an existing database. I have to store Unicode data in the database. Please help.

Regards,
Aradhana
Mar 17 '08 #1
Share this Question
Share on Google+
4 Replies


Expert 100+
P: 700
Hi all,

Can I change the character encoding of an existing database. I have to store Unicode data in the database. Please help.

Regards,
Aradhana
I'm not sure if it can be done (I didn't find that option in manual). Of course you can change the client encoding but it is not the same. You probably will have to
-dump all database
-create new with encoding you want
-restore dumped database
Mar 17 '08 #2

P: 36
I'm not sure if it can be done (I didn't find that option in manual). Of course you can change the client encoding but it is not the same. You probably will have to
-dump all database
-create new with encoding you want
-restore dumped database

Thanx a lot. If I am creating a database using "creatdb" command then where to specify character encoding? Please tell me.
thanx & regards,
Aradhana
Mar 17 '08 #3

Expert 100+
P: 700
Thanx a lot. If I am creating a database using "creatdb" command then where to specify character encoding? Please tell me.
thanx & regards,
Aradhana
Expand|Select|Wrap|Line Numbers
  1. createdb dbname -E encoding_you_want
  2.  
Mar 17 '08 #4

P: 36
Expand|Select|Wrap|Line Numbers
  1. createdb dbname -E encoding_you_want
  2.  
Thank you now the database is storing data in Unicode but while querying the field it shows Hexadecimal codes of the characters starting with &#. Can't we see Hindi characters in the database?

Regards,
Aradhana
Mar 18 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.