| Author |
Message
|
| hoannh |
 Posted: Tue Aug 08, 2006 12:32 am Post subject: how to insert vietnamese data to Oracle database |
 |
|
Newbie
Joined: 12 Jul 2006
Posts: 7
|
Hi All
What should i do to insert Vietnamese data in to Oracle database.
(data store in XML file (encoding ='UTF-8')).
my OS: windows XP.
database: Oracle 9i.
Can anybody show me the solution?
Thanks. |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Tue Aug 08, 2006 1:53 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
make sure you have set the appropriate environment variables (NLS_LANG on Linux) in the broker's active environment to tell the Oracle client what language you're system is running in so that it doesn't mangle the characters when inserting them.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| hoannh |
| Posted: Tue Aug 08, 2006 2:33 am Post subject: how to insert vietnamese data to Oracle database |
|
|
Newbie
Joined: 12 Jul 2006
Posts: 7
|
| yes, i had changed the NLS_LANG in Regedit (AMERICAN_AMERICA.UTF8) but it's incorrect. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Aug 08, 2006 5:26 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Using REGEDIT isn't going to do anything. Who told you that is how you should set an environment variable?
Ask your Windows administrator for the correct way to configure this variable for the Broker User.
And then restart the machine, to make sure that this variable change is active in all of the broker processes.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| hoannh |
| Posted: Tue Aug 08, 2006 6:11 pm Post subject: how to insert vietnamese data to Oracle database |
|
|
Newbie
Joined: 12 Jul 2006
Posts: 7
|
Hi jefflowrey
Can you show me the correct way to configure this variable for the Broker User.
I'm learning Message Broker so there are many thing i don't know.
Thanks a lot. |
|
| Back to top |
|
|
| SandiSan |
| Posted: Wed Aug 09, 2006 1:34 am Post subject: |
|
|
Acolyte
Joined: 01 Apr 2006
Posts: 57
Location: Pune/India
|
Steps for setting NLS_LANG
1. Right Click on My Coumpter select properties
2. Click on Advance Tab
3. click on Environment variable Button
4. In the user variable for administrator section click new
5. enter
new variable name - NLS_LANG
value - Japanese_Japan.UTF8 ( This for japanese for enter the relevent UTF8 in ur case)
Hope this hepls
Regards
SandSan |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Wed Aug 09, 2006 1:42 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
But don't set it to "Japanese_Japan.UTF8".
Set it to whatever value you are using normally. This might even be "Japanese_Japan.UTF8", or it might be "en_US" or "de_DE" or whatever.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| hoannh |
| Posted: Thu Aug 10, 2006 8:50 pm Post subject: |
|
|
Newbie
Joined: 12 Jul 2006
Posts: 7
|
Hi jefflowrey!
I had done but it's incorrect, i think when i write ESQL code, it was changed the format. I tried to use CCSID to 1028 but it's still error. |
|
| Back to top |
|
|
|
|
