Re: Character sets - More questions...

Hi,

I've got UTF8 enabled on my test 8.1.5 on Linux. We're moving towards multilingual support for our web application.

I created some characters using a Japanese Shift-JIS editor, cut and pasted them into my insert statement and inserted into the table.

When this is selected back out again, i get different values and hence what's retrieved from the DB cannot be re-rendered in its original form. Do i need to encode field values into UTF8 prior to insertion and decode on retrieval?

I've tried this against a DB with the US7ASCII character set, and that works fine though. What do i have to do to get back what i popped in.

I've tried setting my NLS_LANG environment variable to Japanese_Japan.JA16SJIS but that doesnt seem to help.

Also, what if i intend to store different mix of characters in the DB e.g. Middle Eastern, Asian, Eurpopean etc, what needs to be done?

I really need all the help and advice i can get. Any books on this subject matter? Thanks!

Regards,
Calvin

DBBOX> desc tsttab;

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FIELD1                                             VARCHAR2(250)

DBBOX> select * from tsttab;

no rows selected

DBBOX> insert into tsttab (field1) values ('$B5A(B $B;q(B $BG'(B $B@;(B $BW>(B');

1 row created.

DBBOX> select * from tsttab;

FIELD1

` F 9 ]

Andreas Jung wrote:
>
> On Tue, May 16, 2000 at 02:05:04PM -0800, David Turner wrote:
> > I really don't have a good grasp of character sets and am reading
> > through the Oracle manual and still don't know which character set would
> > be good for our international databases. One of our DBAs had suggested a
> > character set of utf8, but I don't know why this would be better than
> > one over another. Anyone know the most widely used character set aside
> > from the default?
> >
> > One other thing. It looks like utf8 doesn't support clobs which I need.
> > I need a character set that supports basically all the datatypes.
> >
> UTF8 usually should fit your need. We store XML document (UTF8)
> in CLOBS. Fulltext indexing with Intermedia works perfectly.
>
> That's your choice,
> Andreas
> --
> Author: Andreas Jung
> INET: ajung_at_sz-sb.de
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Wed May 17 2000 - 19:15:29 CDT