amorosi
2003-10-16 22:32:51 UTC
Hi -
I'm trying to store some UTF8 encoded Japanese strings in a Oracle 8i
database. In reading the documentation, it seemed like the
recommended option was to set the character set to UTF8 for the NCHAR
and NVARCHAR datatypes. So my table looks like
myid number,
mydesc nvarchar(1000)
Insert stmts need to look like:
insert into mytable values(id, N'description')
However, how do I then correctly retrieve them? Oracle 9i has a
TO_NCHAR function but I can't find one in 8i.
select mydesc does not appear to return the string I inserted. Do I
need to set a session param? My default lang setting is ASCII7.
To make matters more confusing, I've tried storing the strings in a
VARCHAR field and they appear to work consistently that way. I
realize that the size of the field has to accomodate 3 bytes per char
but is there any other reason I can't just use VARCHAR to store this
data?
thanks in advance
------------------------ Yahoo! Groups Sponsor ---------------------~-->
KnowledgeStorm has over 22,000 B2B technology solutions. The most comprehensive IT buyers' information available. Research, compare, decide. E-Commerce | Application Dev | Accounting-Finance | Healthcare | Project Mgt | Sales-Marketing | More
http://us.click.yahoo.com/IMai8D/UYQGAA/cIoLAA/8FfwlB/TM
---------------------------------------------------------------------~->
To Unsubscribe, send a blank message to: unicode-***@yahooGroups.com
This mailing list is just an archive. The instructions to join the true Unicode List are on http://www.unicode.org/unicode/consortium/distlist.html
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
I'm trying to store some UTF8 encoded Japanese strings in a Oracle 8i
database. In reading the documentation, it seemed like the
recommended option was to set the character set to UTF8 for the NCHAR
and NVARCHAR datatypes. So my table looks like
myid number,
mydesc nvarchar(1000)
Insert stmts need to look like:
insert into mytable values(id, N'description')
However, how do I then correctly retrieve them? Oracle 9i has a
TO_NCHAR function but I can't find one in 8i.
select mydesc does not appear to return the string I inserted. Do I
need to set a session param? My default lang setting is ASCII7.
To make matters more confusing, I've tried storing the strings in a
VARCHAR field and they appear to work consistently that way. I
realize that the size of the field has to accomodate 3 bytes per char
but is there any other reason I can't just use VARCHAR to store this
data?
thanks in advance
------------------------ Yahoo! Groups Sponsor ---------------------~-->
KnowledgeStorm has over 22,000 B2B technology solutions. The most comprehensive IT buyers' information available. Research, compare, decide. E-Commerce | Application Dev | Accounting-Finance | Healthcare | Project Mgt | Sales-Marketing | More
http://us.click.yahoo.com/IMai8D/UYQGAA/cIoLAA/8FfwlB/TM
---------------------------------------------------------------------~->
To Unsubscribe, send a blank message to: unicode-***@yahooGroups.com
This mailing list is just an archive. The instructions to join the true Unicode List are on http://www.unicode.org/unicode/consortium/distlist.html
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/