Re: Re: RE: Re: RE: Re: RE: Toad 10.6 all data in chinese

Miguel,

Advance warning: do not mess with valuable databases, data and NLS_LANG. 
Read everything below before even thinking of changing anything! ;-)


> yeah on my client, my whole client is set to my location correctly but
Do you mean in Control Panel -> Regional Settings when you say "the 
whole client"?

> when i check the NLS_LANG its set to SPANISH_SPAIN.WE8ISO8859P1, i dont
> know if it should say mexico in order to work
I should imaging that it ***might*** possibly be "MEXICAN 
SPANISH_MEXICO.???????" where there is a space between Mexican and 
Spanish in the language portion.

Of course, the character set might be something other than WE8ISO8859P1 
- it depens. You may need to consult the Globalization manual in the 
Oracle docs for advice.

As Mark points out, if you get it wrong, you stand the risk of 
corrupting your data - so best get a test database to play in before you 
make any changes, just in case.

By the way, what does "SELECT DUMP(some_column, 16) FROM table_name 
WHERE ...." give you for the hex codes? Do they look correct for the 
character set you should be using? I'm not sure what character set you 
should be usingin Mexico, WE8ISO8859P1 might, note might, be correct as 
that covers Spanish_Spain - I assume Spanish and Mexican Spanish don't 
have different characters?

If you cannot get a database to play in, ask for a schema in the one you 
are having problems with, and copy a table that you know gives you grief 
and Chinese characters.

HTH


-- 
Cheers,
Norm. [TeamT]


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/