problem with Unicode characters insertion


 
Thread Tools Search this Thread
Operating Systems AIX problem with Unicode characters insertion
# 1  
Old 02-11-2006
problem with Unicode characters insertion

hi,
I have a problem with unicode chars ( chinese, japanese etc ) insertion using sqlplus prompt.
When i wrote a proc program for it i am able to create records.
But when i fore the same query on sql prompt it stores reverse ????? ..some junk.
widechar columns are mapped with NVARCHAR datatype.
I am usin goracle 9i on AIX.
DB settings are:
NLS_LANGUAGE AMERICAN
NLS_CHARACTERSET WE8ISO8859P1
NLS_NCHAR_CHARACTERSET AL16UTF16

I am using ZH_CN.UTF-8 locale on AIX machine.
Could anyone suggest how do i proceed?
Thanks in advance.
Suman
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Positional insertion for multibyte characters

Hi I have a requirement to insert a dot "." after a position in each line, say 110th position. For which, I have written the below command. cat filename | sed 's/./&\./110' > new_filename The code is working fine, but when we have multi byte (2 or 3) characters in the input file, the... (3 Replies)
Discussion started by: tostay2003
3 Replies

2. Shell Programming and Scripting

Awk/sed problem to write Db insertion statement

Hi There, I am trying to load data from a csv file into a DB during our DB migration phase. I am successfully able export all data into a .csv file but those have to rewritten in terms insert statement which will allow for further population of same data in different DB My exiting csv record... (6 Replies)
Discussion started by: bhaskar_m
6 Replies

3. Shell Programming and Scripting

Display unicode characters in zos shell

Hi all, I have a shell script that has several strings with \uxxxx characters distributed within. I would like to display these characters when I execute the script and echo the strings. I am running on zos in an sh environment. Some strings look like this: "Chcete-li pou\u017e\u00edt" <---... (1 Reply)
Discussion started by: adam.wis
1 Replies

4. Shell Programming and Scripting

AWK script problem insertion of code

Hi , I am having two files like this FILE1 #################### input SI_TESTONLY_R_00; input CE0_SE_INPUT_TESTONLY; input CE0_TCLK_TESTONLY; input SI_JTGCLOCKDR_JTAG_R_00; input CE0_TCLK_JTGCLOCKDR_JTAG; input CE0_SE_INPUT_JTGCLOCKDR_JTAG; output SO_TESTONLY_R_00; output... (2 Replies)
Discussion started by: jaita
2 Replies

5. Shell Programming and Scripting

Perl script backspace not working for Unicode characters

Hello, My Perl script reads input from stdin and prints it out to stdout. After I read input I use BACKSPACE to erase characters. However BACKSPACE does not work with Unicode characters that are multi-bytes. On screen the character is erased but underneath only one byte is deleted instead of all... (3 Replies)
Discussion started by: tdw
3 Replies

6. Programming

How to make gl_get_line read unicode characters

Hi, My program uses gl_get_line from libtecla to get user input from terminal. It works fine as long as I enter English at the terminal prompt. However, if I enter other languages, such as Chinese characters, either by typing in or cut-and-paste, the input characters get cleared from terminal... (5 Replies)
Discussion started by: tdw
5 Replies

7. UNIX for Dummies Questions & Answers

remove special and unicode characters

Hi, How do I remove the lines where special characters or Unicode characters appear? The following query does work but I wonder if there is a better way. cat test.txt | egrep -v '\)|#|,|&|-|\(|\\|\/|\.' The following lines show that my query is incomplete. Warning: The word "*Khan" is... (1 Reply)
Discussion started by: shantanuo
1 Replies

8. Shell Programming and Scripting

Help replacing or scrubbing unicode characters

I have a csv (tab delimited) file that is created by an application (that I didn't write). Every so often it throw out a <U+FEFF> (Zero Width no break space) character at the begining of a tabbed field. The charcater is invisible to some editors, but it shows up bolded in less. The issue is... (3 Replies)
Discussion started by: roninuta
3 Replies

9. Programming

unicode problem

on some distributions UTF-32 is the default and i need to change the size of wchar_t to 2 bytes. i tried to compile it with -fwide-exec-charset=UTF-16 but it didn't help. anyone have any ideas? thanks, Akos (3 Replies)
Discussion started by: Akimaki
3 Replies

10. Programming

How to display unicode characters / unicode string

I have a stream of characters like "\u8BBE\u5907\u7BA1" and i want to display it. I tried following things already without any luck. 1) printf("%s",L("\u8BBE\u5907\u7BA1")); 2) printf("%lc",0x8BBE); 3) setlocale followed by fwide followed by wprintf 4) also changed the local manually... (3 Replies)
Discussion started by: jackdorso
3 Replies
Login or Register to Ask a Question
UNICODE(1)                                                    General Commands Manual                                                   UNICODE(1)

NAME
unicode - command line unicode database query tool SYNOPSIS
unicode [options] string DESCRIPTION
This manual page documents the unicode command. unicode is a command line unicode database query tool. OPTIONS
-h --help Show help and exit. -x --hexadecimal Assume string to be a hexadecimal number -d --decimal Assume string to be a decimal number -r --regexp Assume string to be a regular expression -s --string Assume string to be a sequence of characters -a --auto Try to guess type of string from one of the above (default) -mMAXCOUNT --max=MAXCOUNT Maximal number of codepoints to display, default: 20; use 0 for unlimited -iCHARSET --io=IOCHARSET I/O character set. For maximal pleasure, run unicode on UTF-8 capable terminal and specify IOCHARSET to be UTF-8. unicode tries to guess this value from your locale, so with properly set up locale, you should not need to specify it. -cADDCHARSET --charset-add=ADDCHARSET Show hexadecimal reprezentation of displayed characters in this additional charset. -CUSE_COLOUR --colour=USE_COLOUR USE_COLOUR is one of on off auto --colour=on will use ANSI colour codes to colourise the output --colour=off won't use colours. --colour=auto will test if standard output is a tty, and use colours only when it is. --color is a synonym of --colour -v --verbose Be more verbose about displayed characters, e.g. display Unihan information, if available. -w --wikipedia Spawn browser pointing to Wikipedia entry about the character. USAGE
unicode tries to guess the type of an argument. For example, you can use any of the following to display information about U+00E1 LATIN SMALL LETTER A WITH ACUTE (a): unicode 00E1 unicode U+00E1 unicode a unicode 'latin small letter a with acute' You can specify a range of characters as argumets, unicode will show these characters in nice tabular format, aligned to 256-byte bound- aries. Use two dots ".." to indicate the range, e.g. unicode 0450..0520 will display the whole cyrillic and hebrew blocks (characters from U+0400 to U+05FF) unicode 0400.. will display just characters from U+0400 up to U+04FF BUGS
Tabular format does not deal well with full-width, combining, control and RTL characters. SEE ALSO
ascii(1) AUTHOR
Radovan Garabik <garabik @ kassiopeia.juls.savba.sk> 2003-01-31 UNICODE(1)