Sign in or 
- EasyEdit
- Edit tags
-
(what's this?What are these tools?
People just like you can add or edit the content on this site. If you want to try editing, but aren't ready to add to this site, try our demo area.
Read more about editing pages at Wetpaint Central.
) - Report page
Share this
Oracle I18N
Here I note down the battles I have with Oracle dealing with I18N data:
Then you can try RAWTOHEX(col) and DUMP(col) which should show you how it’s encoded in the database.
Also, to find out if a column contains non-ASCII characters, use LENGTH(col) <> LENGTHB(col)
To set the connection charset...
I finally managed to get the right environment variable to use to do the load:
dos> set NLS_LANG=AMERICAN_AMERICA.UTF8
dos> sqlplus ….
Tell sqlplus to exit on error:
WHENEVER SQLERROR ROLLBACK EXIT 5
WHENEVER OSERROR ROLLBACK EXIT 10
|
|
Latest page update: made by
Anonymous
, Jan 22 2009, 1:08 AM EST
(about this update
About This Update
Edited anonymously
16 words added 2 words deleted view changes - complete history) |
|
More Info: links to this page
|
There are no threads for this page.
Be the first to start a new thread.
