Home » Infrastructure » Windows » How to Insert / Retrieve data in Marathi / Hindi font (Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production)
How to Insert / Retrieve data in Marathi / Hindi font [message #636941] Wed, 06 May 2015 05:45 Go to next message
dark_prince
Messages: 121
Registered: June 2013
Location: India
Senior Member
I want to store marathi / hindi data in the table. For that I change the character set to AL32UTF8. But still its not working. Can anyone please tell me how to do this

Thank you in advance
Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636942 is a reply to message #636941] Wed, 06 May 2015 05:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
But still its not working.


It should, so you do it wrong.

Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636943 is a reply to message #636942] Wed, 06 May 2015 06:00 Go to previous messageGo to next message
dark_prince
Messages: 121
Registered: June 2013
Location: India
Senior Member
I followed this step
1. shutdown immediate;
2. startup restrict;
3. alter database character set internal_use AL32UTF8
4. shutdown immediate;
5. startup;

This is the correct one right?? if not please tell me what's wrong here
Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636945 is a reply to message #636943] Wed, 06 May 2015 06:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
I followed this step

And you screwed your database.
I hope you have a valid backup.

Why do you think you can use something that is called "internal_use"?

Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636947 is a reply to message #636945] Wed, 06 May 2015 06:04 Go to previous messageGo to next message
dark_prince
Messages: 121
Registered: June 2013
Location: India
Senior Member
Oh i just installed oracle database. so it does not contain any data.

and about internal_use I search it online and I got this steps with no instruction. And they were saying its working. And I tried nothing work. Totally same old

[Updated on: Wed, 06 May 2015 06:06]

Report message to a moderator

Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636949 is a reply to message #636947] Wed, 06 May 2015 06:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

http://www.orafaq.com/forum/mv/msg/197204/636623/#msg_636623

[Updated on: Wed, 06 May 2015 06:13]

Report message to a moderator

Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636950 is a reply to message #636949] Wed, 06 May 2015 06:16 Go to previous messageGo to next message
dark_prince
Messages: 121
Registered: June 2013
Location: India
Senior Member
well thanks for the video... Mad Mad
But can you tell me whats wrong in above syntax
Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636951 is a reply to message #636950] Wed, 06 May 2015 06:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

"internal_use".

You can't use that.

Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636952 is a reply to message #636950] Wed, 06 May 2015 06:26 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
There is no supported mechanism yo change any existing database character set.
You must CREATE DATABASE with the desired character set only.
Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636953 is a reply to message #636947] Wed, 06 May 2015 06:44 Go to previous messageGo to next message
EdStevens
Messages: 1375
Registered: September 2013
Senior Member
dark_prince wrote on Wed, 06 May 2015 06:04

and about internal_use I search it online and I got this steps with no instruction. And they were saying its working.



============================================================================
Guy: Where did you hear that?
Girl: On the internet
Guy: And you believed it?
Girl: Sure. They can't put anything on the internet that isn't true
Guy: Where did you hear that?
Girl: On the internet. Oh, here comes my date. I met him on the internet. He's a French Model.
Guy 2 (with sly wink) : Bonjour


http://www.youtube.com/watch?v=bufTna0WArc They can't put anything on the internet that isn't true
============================================================================

[Updated on: Wed, 06 May 2015 06:45]

Report message to a moderator

Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636956 is a reply to message #636953] Wed, 06 May 2015 06:54 Go to previous messageGo to next message
dark_prince
Messages: 121
Registered: June 2013
Location: India
Senior Member
Hey guys i get the joke and video thank you.
This time i tried without internal_use but didn't work. The data get stored in english language. Do i have to change language also or not...

if i create new database what will happen to previous one

[Updated on: Wed, 06 May 2015 06:56]

Report message to a moderator

Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636957 is a reply to message #636956] Wed, 06 May 2015 07:07 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>if i create new database what will happen to previous one

Oracle only ever does what it is commanded to do.
What happens to previous DB depends upon what you direct Oracle to do.
Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636961 is a reply to message #636956] Wed, 06 May 2015 07:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
This time i tried without internal_use but didn't work. The data get stored in english language. Do i have to change language also or not...


This is the expected behaviour.
Once again, you cannot go to UTF8 database with an ALTER DATABASE, you have to create a new one.

Quote:
if i create new database what will happen to previous one


How does this matter as you said "Oh i just installed oracle database. so it does not contain any data"?
Just drop it.

Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636962 is a reply to message #636961] Wed, 06 May 2015 07:43 Go to previous messageGo to next message
dark_prince
Messages: 121
Registered: June 2013
Location: India
Senior Member
But in express edition, database is created during installation process so how to drop that one
Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636963 is a reply to message #636962] Wed, 06 May 2015 07:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SQL> DROP DATABASE;
Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636964 is a reply to message #636962] Wed, 06 May 2015 08:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Deinstall and reinstall the whole thing.

Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636974 is a reply to message #636964] Wed, 06 May 2015 23:16 Go to previous messageGo to next message
dark_prince
Messages: 121
Registered: June 2013
Location: India
Senior Member
hello guys. I drop the database. And now for creating new database I found script, I thought before running it i should show that to you guys.


REM ASSUMPTIONS
rem oracle xe has been installed
rem oracle_home has been set
rem oracle_sid has been set
rem oracle service is running

REM SET PARAMETERS
set char_set =al32utf8
set nls_char_set =al16utf16

set ora_dir=d:\app\db\oracle
set version=11.2.0.0
set app_name=xyz
set db_name=%app_name%_db
set db_sid=%db_name%_sid
set db_ins=%db_name%_ins
set sys_passwd=x3y5z7
set system_passwd=1x4y9z

set max_log_files=32
set max_log_members=4
set max_log_history=100
set max_data_files=254
set max_instances=1

set version_dir=%ora_dir%\%version%
set db_dir=%version_dir%\%db_name%

set instl_temp_dir=%db_dir%\instl\script

set system_dir=%db_dir%\system
set user_dir=%db_dir%\user
set undo_dir=%db_dir%\undo
set sys_aux_dir=%db_dir%\sysaux
set temp_dir=%db_dir%\temp
set control_dir=%db_dir%\control

set pfile_dir=%db_dir%\pfile
set data_dir=%db_dir%\data
set index_dir=%db_dir%\index
set log_dir=%db_dir%\log
set backup_dir=%db_dir%\backup
set archive_dir=%db_dir%\archive

set data_dir=%db_dir%\data
set index_dir=%db_dir%\index
set log_dir=%db_dir%\log
set backup_dir=%db_dir%\backup
set archive_dir=%db_dir%\archive
set undo_dir=%db_dir%\undo
set default_dir=%db_dir%\default

set system_tbs=%db_name%_system_tbs
set user_tbs=%db_name%_user_tbs
set sys_aux_tbs=%db_name%_sys_aux_tbs
set temp_tbs=%db_name%_temp_tbs
set control_tbs=%db_name%_control_tbs

set data_tbs=%db_name%_data_tbs
set index_tbs=%db_name%_index_tbs
set log_tbs=%db_name%_log_tbs
set backup_tbs=%db_name%_backup_tbs
set archive_tbs=%db_name%_archive_tbs
set undo_tbs=%db_name%_undo_tbs
set default_tbs=%db_name%_default_tbs

set system_file=%system_dir%\%db_name%_system.dbf
set user_file=%user_dir%\%db_name%_user.dbf
set sys_aux_file=%sys_aux_dir%\%db_name%_sys_aux.dbf
set temp_file=%temp_dir%\%db_name%_temp.dbf
set control_file=%control_dir%\%db_name%_control.dbf

set data_file=%data_dir%\%db_name%_data.dbf
set index_file=%index_dir%\%db_name%_index.dbf
set backup_file=%backup_dir%\%db_name%_backup.dbf
set archive_file=%archive_dir%\%db_name%_archive.dbf
set undo_file=%undo_dir%\%db_name%_undo.dbf
set default_file=%default_dir%\%db_name%_default.dbf

set log1_file=%log_dir%\%db_name%_log1.log
set log2_file=%log_dir%\%db_name%_log2.log
set log3_file=%log_dir%\%db_name%_log3.log

set init_file=%pfile_dir%\init%db_sid%.ora
set db_create_file=%instl_temp_dir%\createdb.sql
set db_drop_file=dropdb.sql

set db_create_log=%instl_temp_dir%\db_create.log
set db_drop_log=db_drop.log

set oracle_sid=%db_sid%

REM WRITE DROP DATABASE SQL COMMANDS TO FILE
echo shutdown immediate;>%db_drop_file%
echo startup mount exclusive restrict;>>%db_drop_file%
echo drop database;>>%db_drop_file%

REM EXECUTE DROP DATABASE SQL COMMANDS FROM THE FILE    
rem sqlplus -s "/as sysdba" @"%db_drop_file%">%db_drop_log%

REM DELETE WINDOWS ORACLE SERVICE
rem oradim -delete -sid %db_sid%

REM CREATE DIRECTORY STRUCTURE
md %system_dir%
md %user_dir%
md %sys_aux_dir%
md %temp_dir%
md %control_dir%

md %pfile_dir%
md %data_dir%
md %index_dir%
md %log_dir%
md %backup_dir%
md %archive_dir%
md %undo_dir%
md %default_dir%
md %instl_temp_dir%

REM WRITE INIT FILE PARAMETERS TO INIT FILE
echo db_name='%db_name%'>%init_file%
echo memory_target=1024m>>%init_file%
echo processes=150>>%init_file%
echo sessions=20>>%init_file%
echo audit_file_dest=%user_dir%>>%init_file%
echo audit_trail ='db'>>%init_file%
echo db_block_size=8192>>%init_file%
echo db_domain=''>>%init_file%
echo diagnostic_dest=%db_dir%>>%init_file%
echo dispatchers='(protocol=tcp) (service=%app_name%xdb)'>>%init_file%
echo shared_servers=4>>%init_file%
echo open_cursors=300>>%init_file%
echo remote_login_passwordfile='exclusive'>>%init_file%
echo undo_management=auto>>%init_file%
echo undo_tablespace='%undo_tbs%'>>%init_file%
echo control_files = ("%control_dir%\control1.ora", "%control_dir%\control2.ora")>>%init_file%
echo job_queue_processes=4>>%init_file%
echo db_recovery_file_dest_size = 10g>>%init_file%
echo db_recovery_file_dest=%log_dir%>>%init_file%
echo compatible ='11.2.0'>>%init_file%

REM WRITE DB CREATE AND ITS RELATED SQL COMMAND TO FILE    
echo startup nomount pfile='%init_file%';>>%db_create_file%
echo.>>%db_create_file%

echo create database %db_name%>>%db_create_file%
echo user sys identified by %sys_passwd%>>%db_create_file%
echo user system identified by %system_passwd%>>%db_create_file%
echo logfile group 1 ('%log1_file%') size 100m,>>%db_create_file%
echo group 2 ('%log2_file%') size 100m,>>%db_create_file%
echo group 3 ('%log3_file%') size 100m>>%db_create_file%
echo maxlogfiles %max_log_files%>>%db_create_file%
echo maxlogmembers %max_log_members%>>%db_create_file%
echo maxloghistory %max_log_history%>>%db_create_file%
echo maxdatafiles %max_data_files%>>%db_create_file%
echo character set %char_set %>>%db_create_file%
echo national character set %nls_char_set %>>%db_create_file%
echo extent management local>>%db_create_file%
echo datafile '%system_file%' size 325m reuse>>%db_create_file%
echo sysaux datafile '%sys_aux_file%' size 325m reuse>>%db_create_file%
echo default tablespace %default_tbs%>>%db_create_file%
echo datafile '%default_file%'>>%db_create_file%
echo size 500m reuse autoextend on maxsize unlimited>>%db_create_file%
echo default temporary tablespace %temp_tbs%>>%db_create_file%
echo tempfile '%temp_file%'>>%db_create_file%
echo size 20m reuse>>%db_create_file%
echo undo tablespace %undo_tbs%>>%db_create_file%
echo datafile '%undo_file%'>>%db_create_file%
echo size 200m reuse autoextend on maxsize unlimited;>>%db_create_file%
echo.>>%db_create_file%

echo @?\rdbms\admin\catalog.sql>>%db_create_file%
echo.>>%db_create_file%

echo @?\rdbms\admin\catproc.sql>>%db_create_file%
echo.>>%db_create_file%

echo create spfile from pfile='%init_file%';>>%db_create_file%
echo.>>%db_create_file%

echo shutdown immediate;>>%db_create_file%
echo.>>%db_create_file%

echo startup;>>%db_create_file%
echo.>>%db_create_file%

echo show parameter spfile;>>%db_create_file%
echo.>>%db_create_file%

REM CREATE WINDOWS ORACLE SERVICE
oradim -new -sid %db_sid% -startmode auto

REM EXECUTE DB CREATE SQL COMMANDS FROM FILE
sqlplus -s "/as sysdba" @"%db_create_file%">%db_create_log%

pause
Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636976 is a reply to message #636974] Thu, 07 May 2015 00:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Michel Cadot wrote on Wed, 06 May 2015 15:10

Deinstall and reinstall the whole thing.


If you have done it you'd be ok now.

Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636981 is a reply to message #636976] Thu, 07 May 2015 02:31 Go to previous messageGo to next message
dark_prince
Messages: 121
Registered: June 2013
Location: India
Senior Member
I uninstall the oracle 11g XE and also reinstall it. But in XE installation, how to set character set is not given..
Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636984 is a reply to message #636981] Thu, 07 May 2015 02:52 Go to previous messageGo to next message
gazzag
Messages: 1113
Registered: November 2010
Location: Bedwas, UK
Senior Member
"The database is created using Unicode(AL32UTF8) character set, which is suitable for global data in any language."
Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636993 is a reply to message #636984] Thu, 07 May 2015 05:06 Go to previous messageGo to next message
dark_prince
Messages: 121
Registered: June 2013
Location: India
Senior Member
Quote:
Japanese, Brazilian Portuguese, and Simplified Chinese language message files are installed in ORACLE_HOME.


But this is does not show how to use marathi language.
Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636994 is a reply to message #636993] Thu, 07 May 2015 05:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Did you recreate the DB with the correct character set?

Re: How to Insert / Retrieve data in Marathi / Hindi font [message #636995 is a reply to message #636994] Thu, 07 May 2015 05:11 Go to previous messageGo to next message
gazzag
Messages: 1113
Registered: November 2010
Location: Bedwas, UK
Senior Member
Quote:

The database is created using Unicode(AL32UTF8) character set, which is suitable for global data in any language.
Re: How to Insert / Retrieve data in Marathi / Hindi font [message #637061 is a reply to message #636994] Sat, 09 May 2015 12:00 Go to previous messageGo to next message
dark_prince
Messages: 121
Registered: June 2013
Location: India
Senior Member
Hello guys sorry for the late reply. I successfully created new database named oraXE. In oradim syntax, i provide system as password. Also in services oraclejobschedular, oracleservice this two are created but tnslistener service and entry in file does not get created. Can you guys please tell me how to do this

also when i try to connect using system as username and password for database oraXE then it gives invalid username password error

[Updated on: Sat, 09 May 2015 12:11]

Report message to a moderator

Re: How to Insert / Retrieve data in Marathi / Hindi font [message #637062 is a reply to message #637061] Sat, 09 May 2015 12:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

>then it gives invalid username password error
BELIEVE this error message!
Oracle does not lie.

post result from OS commands below

lsnrctl status
lsnrctl service
Re: How to Insert / Retrieve data in Marathi / Hindi font [message #637063 is a reply to message #637061] Sat, 09 May 2015 12:37 Go to previous messageGo to next message
Michel Cadot
Messages: 68317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
but tnslistener service and entry in file does not get created. Can you guys please tell me how to do this


1/ You don't need the listener to locally connect
2/ Listener service is created the first time you execute "lsnrctl start".

Re: How to Insert / Retrieve data in Marathi / Hindi font [message #637132 is a reply to message #637063] Mon, 11 May 2015 07:47 Go to previous messageGo to next message
dark_prince
Messages: 121
Registered: June 2013
Location: India
Senior Member
Hello guys. I created the database with AL32UTF8 character set and created a table and also insert data in marathi font just to check whether its working or not. But still no effect. It still showing data in english language.
Please help me out guys its urgent
Re: How to Insert / Retrieve data in Marathi / Hindi font [message #637134 is a reply to message #637132] Mon, 11 May 2015 08:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Search for "arabic" in SQL & PL/SQL forum and check all the mentioned points.

Re: How to Insert / Retrieve data in Marathi / Hindi font [message #637135 is a reply to message #637134] Mon, 11 May 2015 08:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Also check this topic and answer the questions.

Re: How to Insert / Retrieve data in Marathi / Hindi font [message #637384 is a reply to message #637135] Sat, 16 May 2015 04:30 Go to previous messageGo to next message
dark_prince
Messages: 121
Registered: June 2013
Location: India
Senior Member
Thank you guys for your help. It worked. Thank you all...
Re: How to Insert / Retrieve data in Marathi / Hindi font [message #637395 is a reply to message #637384] Sat, 16 May 2015 14:02 Go to previous message
Michel Cadot
Messages: 68317
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

OK, now tell us how you make it works.

Previous Topic: Replicating Database
Next Topic: ODBC Drivers
Goto Forum:
  


Current Time: Fri Dec 09 16:03:39 CST 2022