HomeОбразованиеRelated VideosMore From: venkatesh sankala

CHANGING THE CHARACTER SET TO AL32UTF8

78 ratings | 28379 views
By using these steps you can change the oracle database character set to AL32UTF8
Html code for embedding videos on your blog
Text Comments (23)
Ali Elsayed (2 months ago)
it works, really thank you
Nang Nguyen (8 months ago)
Thanks you! very useful
CagtGT (1 year ago)
You save me!!! Thanks
venkatesh sankala (1 year ago)
CagtGT always welcome dude
grandmapants (1 year ago)
What was the original CHARACTER SET?
venkatesh sankala (1 year ago)
grandmapants mine was AL32UTF16
Syamsul Mustaqim (1 year ago)
extremely useful, this is the way IT question should be answered, simple and practical.
MrKSSREDDY (1 year ago)
Thank you !
venkatesh sankala (1 year ago)
MrKSSREDDY 👍
Shankar Narayanan (1 year ago)
Hi Venkatesh - Can i use these steps in oracle 11.2.0.4 version, my database having characterset US7ASCII
Simo Bkr (1 year ago)
what is password ?
venkatesh sankala (8 months ago)
Simo Bkr I used username as sys as sysdba So password is sys
Chandan M P (10 months ago)
Password is your sys password which DBA used to install your database
Umer Saleem (2 years ago)
SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER LIKE '%CHARACTERSET%'; SHUTDOWN IMMEDIATE; STARTUP RESTRICT; ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8; ALTER DATABASE CHARACTER SET AL32UTF8; SHUTDOWN IMMEDIATE; STARTUP; SELECT * FROM V$NLS_PARAMETERS WHERE PARAMETER LIKE '%CHARACTERSET%';
S Cavalier (2 years ago)
These steps are not in any official Oracle documentation for a good reason - they are not supported. Performing these steps will cause your database to be corrupted beyond repair. Best to follow the steps to migrate the characterset as per official documentation.
venkatesh sankala (2 years ago)
but I'm using for past 4 yrs I didn't get any problem. So its safe to use😊
Tùng Đặng Duy (2 years ago)
Thanks
Komil Gulboev (2 years ago)
Bhai You saved my day Thank You
Edward P (2 years ago)
Very good one. thanks
Jiggu Pk (3 years ago)
thank you so much venkatesh i have been trying since a week. please upload more video regarding debugging in obiee, sql and plsql
venkatesh sankala (3 years ago)
+Jiggu Pk sure jiggu i will definitely upload video in short tym
Yavuz Peksen (3 years ago)
Mate, You saved my life. I have tried to fix the problem for several hours. Thank you so much..
venkatesh sankala (3 years ago)
+Yavuz Peksen pleasure is mine bro check out the other videos

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.